Using IF formula to update status based on % complete column

AshleyV33

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

tori.wyne

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!

tori.wyne

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.

AshleyV33

@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)

tori.wyne

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!

AshleyV33

Thank you @tori.wyne ! This is exactly what I needed - I always forget to use automations to my advantage. Thanks again :)