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
-
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?
-
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
Categories
Check out the Formula Handbook template!