SOLVED

Show/hide columns based on 2 conditions

Copper 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 (Copper Contributor)
Solution

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

 

1 best response

Accepted Solutions
best response confirmed by RehmanR (Copper Contributor)
Solution

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

 

View solution in original post