How to auto populate cells after they are sent to a sheet from a form.

TG_Controls_PM

I have a form which requires roughly 10/50 of the columns being filled, since not all of the information is know at time of entry. Each row is one job, and the job has roughly 14 steps in the production process, with other information in each row.

Once the form receives the input, and the input gets sent to a new row in a sheet, how can I auto populate roughly 10 of the columns to show those steps in my process haven't started yet?

404.IRL

Good day, @TG_Controls_PM If I understood correctly, this should do the trick:

• Create a workflow for the sheet
• Trigger - When rows are added
• Run workflow - When triggered
• Condition - None unless you have one
• Change cell value - select the cells you want to populate
• Repeat step above

404.IRL

Good day, @TG_Controls_PM If I understood correctly, this should do the trick:

• Create a workflow for the sheet
• Trigger - When rows are added
• Run workflow - When triggered
• Condition - None unless you have one
• Change cell value - select the cells you want to populate
• Repeat step above

TG_Controls_PM

When "change cell value" goes into effect, I want it to equal an equation, which I can't figure out how to do.

Andrée Starå

Hi @TG_Controls_PM

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!