Smartsheet if then not functioning

Michael Figone

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.

Frank Falco

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

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

Michael Figone

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

Frank Falco

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"))