Updating Fields Based on Input

Mike Rini

I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank.

Q: I know how to allocate the Budget for each month, but is there anyway to populate the Monthly Budget fields after the form is submitted? The formula for doing this is easy, but I think it'll get overwritten by the Form if someone submits Monthly Budgets and it populates those fields.

Grateful as always for any help.

Mike

Andrée Starå

Hi @Mike Rini

You can add a so-called helper sheet where you collect the submissions and then they would automatically move over to the main sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

Mike Rini

Seems like the same problem would present itself, no? If the rows is copied to another sheet, it would then overwrite any formulas if it was populated, right? Or am I misunderstanding what you're saying?

Andrée Starå

@Mike Rini

If I understand you correctly, it should work with a column formula. The column formula would overwrite the copied values.

Make sense?