Typebot
Log in

Share feedback, ideas and get community help

Updated 7 months ago

Google Sheet insert row bellow

@@data4shiny
·
This is my google sheet:

I have a formula pre filled on this sheet

When typebot save the answers/result starts saving on the row bellow

How can I make typebot save the results starting by the first row and so on?
Attachment
c0635f20-c2c2-4667-adc3-dc48968c455b.jpg
1
A
B
@
6 comments
AApploader
Does the formula need to be in the cell of the sheet? You could use Set Variable for the formula and insert the variable in the cell.
BBaptiste
This is not possible unfortunately. I suggest that you then sort the spreadsheet?
@@data4shiny
Thanks @Apploader I will try it.
NNidzam
You could use ARRAYFORMULA.
@@data4shiny
Hi @Nidzam thanks for your time. I will try it!
@@data4shiny
@Nidzam It worked! This is the final formula:

ARRAYFORMULA(IF(COUNTA(A2:AH2)=0; ""; IF(COUNTIF($AG$2:$AG$1009; AE2) > 0; TRUE; FALSE)))

Thanks for your help. 😊
Add a reply
Sign up and join the conversation on Discord