Automatically add formula to new rows
I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is created, it also triggers Zapier functions so I can't just drag the formula down into empty rows or it causes a Zapier problem.
Thanks!
Answers
-
Hi Nataleigh,
How are the rows added? Top, bottom? Are there at least two rows with the formula before or after?
Can you describe your process in more detail and maybe share 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)
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The rows are currently added to the bottom. The formula is in at least two rows before the last empty row but not after it for the reasons below.
We have a Ninja form on our website. When a person completes that form, a Zapier zap is triggered so the information gets added to smartsheet at the bottom. Another zap sends that person a thank you email.
If I copy the formula into what are now "empty" rows, Zapier will think it's new information and look for the email address to send the thank you email which will cause an error.
Because we're watching our number of submissions, we want to make sure there are no duplicates. So, I set up a formula so a box would get checked if a duplicate email is detected. =IF(COUNTIF(Email:Email, Email@row) > 1, 1).
-
I too am having the same issue. For the most part I got it to work by incorporating ISBLANK into the formula, however on some sheets I am still having issues with the formula despite that. Still trying to figure it out.
-
Have you tried/would it work if you add them to the top instead? Maybe it's just a temporary glitch.
Hope that helps!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I am having the same issue
-
How are the rows added? At the bottom or the top?
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 week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Are you guys still having this problem? I've noticed this with just one of my sheets. It's one where I copy and paste (every morning) data from an Excel spreadsheet into this sheet. I have a bunch of calculated fields on the first line of the sheet that used to automatically copy down to the new rows, but for some reason they stopped.
I tried creating a 2nd row at the top to make sure that wasn't the issue, but they're still not copying...
Weirdly, I have another sheet (for another report) where I do the same thing and that one is working fine....
-
And there I go answering my own question..... I noticed in the sheet that wasn't working, the top row was "locked". I unlocked it and my calculated fields started copying again. Good to know....
-
Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!