Automation

Nicole_Codi17

I created an automation that when a column is checked, the status changes to Complete and the % completed to 100%. I am trying to figure out how to revert back to previous status and % Completed if the box is checked error.

Thanks all!

heyjay

Status Column = IF(Column@row = 1, "Complete", "")

% completed Column = IF(Column@row = 1, "100%", "")

This work like this.

Nicole_Codi17

Thanks Jay! what if I already have formulas in status column?

Nicole_Codi17

Hi all,

I am trying to get this automation set up and really need help. In my status column, I already have a formula based on my %Complete. Is there a work around to have the status column revert to previous status in the event the check box was checked by mistake?

John_Foster

Hi @Nicole_Codi17,

It may be possible, but would depend on the formula you are already using. Can you post your current formula so we can take a look at it?

Thanks,

John