Show/hide columns based on 2 conditions

Occasional Contributor


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')


1 Reply
best response confirmed by RehmanR (Occasional Contributor)

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')