Sign in to join the conversation:
Hello,
I have formulas applied to a few columns in my sheet. When I manually enter a new row the formulas are applied. However, when a new row is added because someone filled out a form the formula doesn't get applied. How can I fix this?
Hi Kelly,
First check that the below conditions are met.
If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.
Conditions That Trigger Formula Autofill
You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:
More info:
What's the formula/formulas? Are you referencing any Sheet Summary Fields?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help 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!
Yes, here is the screenshot. All information is sample data and not proprietary.
New quotes get submitted with a form sent to a vendor and act as a parent to the invoices that get manually added later. There are formulas in the "Amount Outstanding" column to calculate invoices and quotes (as seen in red and green). But because there are not formulas in the invoice rows a new quote row added by form cannot take advantage of the Formula Autofill Triggers. Is there a way around this?
@Kelly McGill Yes, with the right structure, we can make it work. One way would be to have the form added to the top of the sheet and then move it to the correct position. You'd need to add at least two rows with the formula structure for it to autofill. We can probably make it work if you add it at the end as well if you prefer.
What do you think?
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
