Formula Help

jmtea

I am trying to use an IF contains formula to look at the assignee column and the notified column for two different names and continue to get #unparseable. Does anyone have insight or the correct formula?

NickStaffordPM

Could you post your formula? I will take a look at the syntax to do a root cause analysis!

jmtea

I am trying to use an IF CONTAINS formula

=IF(CONTAINS("Person", Assignee@row + " " Notified@row))

heyjay

You can follow this formula

=IF(CONTAINS("Jacket", [Clothing Item]:[Clothing Item]), "True", "False")

After your quotes, you need to add a + symbol if you are trying to join text

You are missing your TRUE arguement.

NickStaffordPM

Agreed with heyjay. As a helpful tool moving forward, when you are typing a formula in smartsheet, it typically oulines the synthax needed to have a successful formula. Referencing this will help you avoid missing terms in the future :)