Forum Discussion
Sharepoint List Edit Form Conditional Formatting for Yes/No field
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!
Joe Ayre Good morning,
Did you test on a Yes/No type column? I have been able to do it with everything but this type. I even created a test Choice column with yes no as the selections and it worked that way but I would prefer not to have to change my column just for this.
I did double check my name on the couple of fields I am trying this for and that does not seem to be the issue.
Here are some screenshots. First is the Field name and second is the formula I used. No matter what value is in the Worked in Sprint column (yes or no) the field does not appear.
Thoughts?
cmaly yes - I did test with a Yes/No column.
Looking at your screenshot, I can see that the internal name of your 'Worked in Sprint' column is actually "Worked_in_Sprint' - the %5Fx0020%5F represents an underscore character.
I would try again with the following formula:
=if([$Worked_in_Sprint]==false,'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.