SharePoint List - conditional formula to show or hide columns - Not working

Question

Current form details

-78 fields , sample image - (267334)
-Category Field is $IncidentType , single choice, drop-down menu, default value is blank, not a required field

• formula used is in the (26733) , =if([$IncidentType] == 'Privacy', 'true', 'false')

Feedback

I have tried different variations of this formula,
exchanging the 'true' and the 'false',
tried "<=' instead of '==',
i've copied the formula from the website and changed the values,
typed it in manually.
change the form of "IncidentType' from "Drop-Down Menu" to "Radio Button"
Change the IncidentType form fields
Changed the Column Name

and nothing works... Any other ideas?

Screen Shots

Answer 1

Hi @Muki ,
Can you tell me what type of column you want to be hidden(The column that uses the conditional formula)?
I performed the test based on your description.
$IncidentType , single choice, drop-down menu, default value is blank, not a required field

I created a column named test using conditional formula: single choice and Yes/No were both tried. Showing or hiding the test column according to the value of $IncidentType works well.
Conditional formula: =if([$IncidentType] == 'Privacy', 'true', 'false')

Since I can't reproduce your situation, we need to narrow down the problem and try some things.

1. Whether all SharePoint lists have the same problem? You could create a new SharePoint list to check.
2. You could try to clear browser cache then restart it.
3. Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.
4. Are other users with permissions facing the same problem? View through another computer or account.
5. Check if the same issue occurs with other SharePoint site collections.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

- I've tried it with several different fields but the one that i'm trying to apply them to are "Yes/No" Checkboxes

1.Whether all SharePoint lists have the same problem? You could create a new SharePoint list to check.
I've actually experienced this with other sharepoint list. sometimes it works, sometimes it doesn't. i have not found the exact formula that makes it work BUT most of the time it doesn't.
2.You could try to clear browser cache then restart it.
- cleared cache + cookies , no luck
3.Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.
I am using EDGE but have also tried it with Chrome. no luck
4.Are other users with permissions facing the same problem? View through another computer or account.
As a site owner, there could be permissions problems? Does this cascade to other SharePoint things?
5.Check if the same issue occurs with other SharePoint site collections

Are there site features that need to be activated for this to work? Our IT department generally blocks certain items for security.

Answer 3

I was hoping to avoid having to rebuild it and test again.

BUT

it worked. I went and rebuilt the whole thing again and the conditional formatting formulas are working.

Thanks for your help