1

I have a choice column named "Catalogue". one of the choices is Digital. I have another choice column named Digital Strategy Areas that I only want to show when Digital is selected from Catalogue.

My conditional formula for the Digital Strategy Areas is:

=if([$Catalogue] == 'Digital', 'true', 'false')

enter image description here

enter image description here

the column goes grey when I hit save, however it does not show up when i select Digital in Catalogue as you can see above, and I don't know why?

3
  • Catalogue is single selection choice column or multiple selection choice column? Commented Nov 16, 2023 at 12:14
  • its a choice column but it does not allow multiple sections
    – knowlec
    Commented Nov 16, 2023 at 12:19
  • ok, please check my answer given below and verify all points. Let me know if it works for you or if you still facing this issue. Commented Nov 16, 2023 at 12:21

1 Answer 1

0

Your SharePoint conditional formula and syntax looks good to me.

I will suggest you to verify below things:

  1. Make sure you are using correct internal name of "Catalogue" in the SharePoint conditional formula. You can get the exact internal name of your SharePoint columns by following this article: How to find the Internal name of columns in SharePoint Online?
  2. Make sure you are using the formula with exact case as shown in your question - if, true and false, etc. should be in small letters as it might not work with capital or mixed letters.
  3. Make sure Catalogue column is a choice column with single selection allowed as choice columns with multiple selections are not supported in SharePoint conditional formulas.

Check this Microsoft official documentation for more information and steps to apply conditional formulas in SharePoint list forms: Show or hide columns in a SharePoint list or library form

2
  • 1
    thank you Ganesh, once i checked the internal name of the Catalogue column in the url link, it was set to an old column name "Catalogueofservices". once i changed the conditional formula to that column name, it now works! thanks again
    – knowlec
    Commented Nov 16, 2023 at 12:31
  • You're welcome, I am glad it worked for you! Commented Nov 16, 2023 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.