Forum Discussion
Solved
Show/hide columns based on 2 conditions
I want to make a SharePoint List column show/hide based on 2 conditions with OR operator. I have tried the following formula variations and nothing is working. =IF(OR([$DocumentType]=='New...
SOLUTION: After trying hours, figured out that following formula elements should be in small letters:
- if
- true
- false
The following formula works:
=if([$DocumentType]=='New' || [$ChangeinMetaData]=='Yes', 'true', 'false')
SOLUTION: After trying hours, figured out that following formula elements should be in small letters:
- if
- true
- false
The following formula works:
=if([$DocumentType]=='New' || [$ChangeinMetaData]=='Yes', 'true', 'false')