Multiple IF Statements

hello,

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.

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!