Append to a google sheet output without removing existing formulas of the google sheet

[AJT01]

Hi Everyone, I'm trying to append some data to the bottom of a google sheet. The append is working but when the new data is added it removes all formulas that existed in the google sheet. Is there a way to stop this happening?

[TheOC]

hi @AJT01 

The comments of this thread might be useful, they talk about this exact problem:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-How-to-Guide-to-Google-Sheets/t...


Hope this helps!
TheOC

[AJT01]

Hi, I've had a look through and can't see which part refers to the same issue I'm having, perhaps I'm not wording it correctly. We have array formulas set up in the header row, and after running the append it overwrites these with text. I need the array formulas to keep working.