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?
Please see attached, formula has worked for a long time an typically pulls the data from another sheet as intended. I looked today and suddenly I have a "2" in a lot of the empty fields, and cannot figure out why. The formula I am using: =IFERROR(IFERROR(INDEX({PERFECTION YARD CHECK RO #}, MATCH(VIN@row , {PERFECTION YARD…
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…
