I want to add a IF statement to a simple vlookup that checks something additional.

Does anyone have any suggestions on adding a IF to this current formula that would say IF "Approved" than "Excluded" else this would pull from another sheet or be "Not Started".

I made the automation looked for status changes to "Approved" for the column to change to "Excluded" but that wasn't working.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!