Automatically add formula to new rows

Automatically add formula to new rows

NataleighNataleigh
edited 12/09/19 in Formulas and Functions

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!

Tagged:

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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, [email protected])

    Hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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 protected]) > 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. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Have you tried/would it work if you add them to the top instead? Maybe it's just a temporary glitch.

    Hope that helps!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I am having the same issue

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @markrecital

    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, [email protected])

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • MCorbinMCorbin ✭✭✭✭✭

    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....

  • MCorbinMCorbin ✭✭✭✭✭

    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....

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @MCorbin

    Glad you got it working!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.