IF HAS Formula for Contact List


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


  • 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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!