Hi, I was able to create a formula based on this posting from Microsoft (link below) and it works great. However, I want to be able to write it so it looks at 2 different values in a field to show ... Jul 03, 2
What formula do you think i could use for my case? I also compared it against a value and it still isn't working properly =if(substring([$Code_x003a__x0020_Name], indexOf([$Code_x003a__x0020_Name], ';#') + 2, 1000) == 'All: BHHS - Alliance', 'true', 'false') ...
Working with SharePoint reminds me of watching James Bond movies – you think you have seen them all and know all the cool spy gadgets, yet, a new movie comes out, and there is a set of the new tricks in the book. The same with SharePoint – it is like a goldmine of cool ...
followed the guidance in this linkhttps://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#specify-conditional-formula-to-show-or-hide-columns, however conditional formula appears to have an issue with the space between the column name "Thir...
Thank you for posting in this community. First of all, JSON format and conditional column both control the display of this column based on the values of other columns, but not based on the logged-in user. Second, the minimum level of permissions set in SharePoint is the item (wh...
I’ll politely let them know you don’t need IFs in conditional formatting formulas, and that their formula can be reduced to something like: =A2=”Something” I’m going to go out on a limb and say there’s never a need for an IF in a conditional formatting formula. ...
"A single value for column '% Volt Drop' in table 'Cable Schedule' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." % Volt Drop should ...
(2) Presentation of different Rows references in ALLSELECTED: Looking at the rendering of each of the different fields in the screenshot, you may find the difference and find the result you want. Here is a demo , please try it: https://qiuyunus-my.sharepoint.com/:u:/g/pe...
In the formula field, enter the following formula: =$D2>=15 Click the ‘Format’ button. In the dialog box that opens, set the color in which you want the row to get highlighted. Click OK.This will highlight all the rows where the quantity is more than or equal to 15.Similarly...
SharePoint Online Like 0 Reply 1 Reply Replies sorted by Newest DaveMehr365 MVP Sep 24, 2024 Hello Undenius i try to use the example from Microsoft https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#specify-conditional-formula-to-show-...