AnsweredAssumed Answered

evaluate multiple columns with contains function

Question asked by koolgeex on Dec 6, 2017
Latest reply on Dec 6, 2017 by emha

I have column A (It is a choice type column with 3 options - Z, X, or Other)

I have column B (it is a choice type column with 3 options - U, K, Other)

I have coluimn C (It is a single line of text column)

 

If Column A OR Column B has "Other" checked off, then column C should show.

 

I have tried this rule applied to the panel for columns C:

  • not(contains(ColumnA, "Other")) || not(contains(ColumnB, "Other"))

 

What's the proper syntax?

Outcomes