Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 am getting a lot of REF errors for my predecessors and I can't figure out why. At first I thought I might have REF for predecessors to predecessors but that's not the case. When I export the file into Excel it shows the IDs in the place where it shows REF in SS. Each time I refresh the file I feel like different values…
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
