Multiple IF Statements


I have this formula that works great: =IF(Status@row = "Complete", 1). I change the "Status" to complete and the "Done" column box is checked.

However, when I change the Status to "Abandoned" or "Reassigned" I also want the "Done" column box checked "Complete."

How do I do multiple IF functions? The "Nesting IF Functions" help page was...well, no help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!