Formula Help - Automating Status

Lchicklis

Hi there,

I am wondering if its possible to use a formula to automate a status column. For example, when someone submits an intake request through a form and a new row is added to my sheet, is it possible to have the status automatically change to "Intake"? Further, when someone approves the intake (i.e. Laura Approval column changes to 'Approved'"), can the status change to "Charter"? Not sure where to start to do something like this. Any help is much appreciated! 

Thank you!

Andrée Starå

Hi,

Yes, it's possible but be aware that you then can't change the status manually because then the formulas would be deleted. 

I'll get back to the post a little later to give you an example. 

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Try something like this.

=IF([Laura Approval]@row = "Approved"; "Charter"; "Intake")

The same version but with the below changes for your and others convenience.

=IF([Laura Approval]@row = "Approved", "Charter", "Intake")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Lchicklis

Yes it worked!! Thanks so much! I appreciate the help.

Andrée Starå

Excellent!

Happy to help!