IF HAS Formula for Contact List

Options

I want the "Office(s)" field to display "OSA" if the Task Owner contains All. The Task Owner may have multiple contact lists selected.

Current Formula: =IF(CONTAINS(All, [Task Owner]@row, "OSA", ""))

Error: #Unparsable

Columns:

  • Task Owner - Contact List
  • Office(s) - Text


If I change the formula to include quotes about "All", the error says "Incorrect Argument Set".

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!