Forum Discussion

cmaly's avatar
cmaly
Brass Contributor
Jul 15, 2020
Solved

Sharepoint List Edit Form Conditional Formatting for Yes/No field

Hi, I have been able to successfully add conditional formatting to my columns in my Edit form based on the Microsoft link below.  However, I can't get it to work for a Yes/No column.  I have used th...
Lists
SharePoint Online
  • cmaly's avatar
    cmaly
    Jul 22, 2020

    Thank you for your response.  I was unable to make it work with my column as it was.  I tested on a Test Sharepoint list that I have and confirmed it was the name of my column causing me trouble.  So I ended up creating a new Yes/No column that the naming did not have the x0020 between the words and now it is working fine.

     

    Thanks again!

ganeshsanap's avatar
ganeshsanap
MVP
Jul 20, 2020

cmaly I think you are facing this issue because you are using wrong internal name of your column.

Check below link for finding correct internal name of your column:

Find the internal name of SharePoint column 

 

Assuming internal name of your column is "BooleanCol", either of below should work for you:

 

=if([$BooleanCol]==true,'true','false')

 

OR

 

=if([$BooleanCol],'true','false')

 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.

  • cmaly's avatar
    cmaly
    Brass Contributor
    Jul 22, 2020

    Thank you for your response.  I was unable to make it work with my column as it was.  I tested on a Test Sharepoint list that I have and confirmed it was the name of my column causing me trouble.  So I ended up creating a new Yes/No column that the naming did not have the x0020 between the words and now it is working fine.

     

    Thanks again!

Resources