I’m working on building a compliance audit tool, where one of the columns [Compliant] is marked ‘Yes or No’ using an expression that is based on the inputs from the previous questions.
The issue I am running into, is that one of the fields is optional, where not all users will see (based on geographic market). With this column hidden from some, my ‘If(and’ formula will not work correctly.
This is my current formula which works when all the questions are displayed:
if(and([Clean] = “yes”,[Labeled]=“yes”,[Funnel]=“yes”,[Containment]=“yes”,[CA Only]=“yes”),“yes”,“no”)
The issue, is when [CA only] is hidden, the formula will not work correctly, as the user can not select ‘Yes or No’. I was attempting to add a nested ‘Or’ statement, but am having issues with it working.
Any help is appreciated.