Smartsheet if then not functioning

What am I missing in this formula that is not populating a cell based on another celll?


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


Thanks.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!