SOLVED

Show/hide columns based on 2 conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-3245624%22%20slang%3D%22en-US%22%3EShow%2Fhide%20columns%20based%20on%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245624%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20SharePoint%20List%20column%20show%2Fhide%20based%20on%202%20conditions%20with%20OR%20operator.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20following%20formula%20variations%20and%20nothing%20is%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(%5B%24DocumentType%5D%3D%3D'New'%2C%5B%24ChangeinMetaData%5D%3D%3D'Yes')%2C%20'True'%2C%20'False')%3C%2FP%3E%3CP%3E%3DIF(%5B%24DocumentType%5D%3D%3D'New'%2C%20'True'%2C%20IF(%5B%24ChangeinMetaData%5D%3D%3D'Yes'%2C%20'True'%2C%20'False'))%3C%2FP%3E%3CP%3E%3DIF(%5B%24DocumentType%5D%3D%3D'New'%20%7C%7C%20%5B%24ChangeinMetaData%5D%3D%3D'Yes'%2C%20'True'%2C%20'False')%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3245624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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 (New 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')