Formula Help

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?

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭

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

    If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.

    Thanks!

    Nick Stafford

  • I am trying to use an IF CONTAINS formula

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

  • heyjay
    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
    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 :)

    If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.

    Thanks!

    Nick Stafford

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!