Forum Discussion
cmaly
Jul 15, 2020Brass Contributor
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...
- 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!
Joe Ayre
Jul 16, 2020Brass Contributor
I've tested this and it works OK for me. The formula you have listed has the correct syntax. One thing you might want to check is the internal name of your SharePoint column. The formula you list relies on the internal name being 'Category' - if it's anything else then it just won't work.
To check the internal name, go to your list/library settings, click on the 'Category' column in the 'Columns' section and in the address bar of your browser, right at the end you should see something like '&Field=Category' (if 'Category' is indeed the internal name). If it is something different then you need to use this in your formula.
Hope that helps.
cmaly
Jul 16, 2020Brass Contributor
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?
- Joe AyreJul 20, 2020Brass Contributor
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.