Google Sheet insert row bellow
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?
5 Replies
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.
This is not possible unfortunately. I suggest that you then sort the spreadsheet?
Thanks @Apploader I will try it.
You could use ARRAYFORMULA.
Hi @Nidzam thanks for your time. I will try it!
@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. 😊