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

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!
Answers

Hi Ashley, can you share what additional conditions you're trying to add? This might determine the formula needed and help better understand the unparsed error.

@tori.wyne I'm hoping to have my status column update based on the % complete as follows: "Not Started" (when % complete is 0), "In Progress" (when % complete is >0 but <1) or "Complete" (when % complete is 1)

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!

Thank you @tori.wyne ! This is exactly what I needed  I always forget to use automations to my advantage. Thanks again :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!