Formula Help - Automating Status

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!

Find more posts tagged with

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?