Mar 03 2022 06:45 AM - edited Mar 03 2022 07:06 AM
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',[$ChangeinMetaData]=='Yes'), 'True', 'False')
=IF([$DocumentType]=='New', 'True', IF([$ChangeinMetaData]=='Yes', 'True', 'False'))
=IF([$DocumentType]=='New' || [$ChangeinMetaData]=='Yes', 'True', 'False')
Mar 03 2022 09:27 AM - edited Mar 03 2022 09:31 AM
SolutionSOLUTION: After trying hours, figured out that following formula elements should be in small letters:
The following formula works:
=if([$DocumentType]=='New' || [$ChangeinMetaData]=='Yes', 'true', 'false')