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
Check out the Formula Handbook template!