Nov 22, 2022 · I've successfully used non "not equal to" formulas to conditionally show/hide columns in SharePoint default forms. Does anyone know if it is possible to use a "not equal to" …

Feb 25, 2025 · 1 Answer Unfortunately, this is a limitation of SharePoint calculated column formulas. You cannot use Lookup columns in the SharePoint list calculated column formulas. …

Sep 9, 2015 · I have been trying to figure this out and I cannot solve it. I am trying to create something which say IF column a = "High" AND Column b ="High" THEN "Red" should be ...

Nov 30, 2018 · Is there any easy way to write and validate a SharePoint calculated field formula? I am trying to find a formula builder like CAML builder!

Oct 22, 2024 · I am preparing an Excel file that reads and aggregates data from another Excel file stored on Sharepoint. This works with simple references, but when using a reference to the …

Jun 24, 2020 · In SharePoint online, it's not supported that formula contains reference to other fields when setting column default value. Only caculated column can cotain other columns.

May 2, 2016 · I have been working on a calculated column formula and have gotten stuck. I have a list with several columns the formula is looking at. First column is a Due Date column that is …

Nov 17, 2024 · I am trying to build out a SharePoint List validation formula. I can get the first part to work but when I try to add the second part, it will not work for either.

10 I would like to be able to use today's date in a calculated column in a SharePoint list to, for example, determine whether a task is overdue. There is a well-documented trick that involves …

Dec 15, 2020 · I am new to SharePoint and Power Automate. I have to put multiple conditions in SharePoint list validation settings. Example: =IF(ISBLANK([Unit Amount]),TRUE,[Unit …