Smartsheet if then not functioning

What am I missing in this formula that is not populating a cell in a column based on cell in another column (same row)?

=IF[Workstream]="Market Intelligence" THEN [Workstream Lead]="Charlie Brown"

Thanks.

Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭

    This is the code for the [Workstream Lead] column/cell in each row

    =IF([Workstream]@row="Market Intelligence" , "Charlie Brown")


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

  • Thank you! That worked. What if I want to add 2 more IF statements onto the end of this?

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    edited 02/11/20

    Then you are doing a nested IF statement

    So it would be IF(logical_expressionvalue_if_true[value_if_false]); you would add another IF statement to the optional value_if_false condition and so on

    =IF([Workstream]@row="Market Intelligence" , "Charlie Brown",IF([Workstream]@row="Something else" , "Another character"),IF([Workstream]@row="Another thing" , "Yet another"))


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!