Using IF formula to update status based on % complete column


Hi all -

Need some help with an IF formula

Goal: status updates automatically to "Not Started" (when % complete is 0), "In Progress" (when % complete is >0 but <1) or "Complete" (when % complete is 1) based on value entered in "% Complete Column"

I've started here, and this formula works; but when I include additional conditions I get an 'unparsed' error so clearly I'm breaking my formula somehow. Has anyone done this or can you help!?


Best Answer

  • tori.wyne
    Answer ✓

    Ashley, got it thank you I see that I missed that in your initial post. I think this would be easier to accomplish with Automation. I attached a screenshot of what this would look like, but let me know if you have any questions!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!