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?
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
