Best answer

New row in Google Sheets copies style from previous row

  • 27 June 2020
  • 1 reply
  • 262 views

Hi,

Whenever a new row is added from Zapier to my Sheet in Google it copies the formatting & style from the previous row, for example in the photo attached:

The row marked in green was like row #3 and i added a Strikethrough style (manually), the row marked in RED is a new entry from WPForms and it copied the Strikethrough style from row #4, but i don’t want it to have an style.

 

How can i fix this?

 

Thanks.

icon

Best answer by Liz_Roberts 1 July 2020, 19:30

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +8

Hi @eliast9 ,

Thanks for reaching out! You have stumbled upon a known integration quirk!

To sidestep this, using your example (referencing Row 4 + 5), you would update Row 5 instead of creating Row 5. To do this:

  • Use a Find Row action to find the bottom row (in this case Row 5)
  • Then use a Formatter Action to add 1 to the current Row number
  • And lastly, use the Update Row action and the Formatter number as the Custom Value

Let us know if you have any questions- always happy to help!