How to Insert in Google Sheet when a row has formulas

Question

I find myself in a somewhat strange/particular sitation.
I have a google sheet in which I have a column A with a title in A1 and in row A2 I set up a cell with data validation that pulls information from a drop down menu.
When, with typebot, I try to enter the value in row A2 what happens is that row A3 is filled but not A2 (despite being empty)
Any ideas on how to get the value into row A2 so that all the formulas I have within the sheet work correctly?

Baptiste · Answer

Can you clearly describe it by following this template:Steps to reproduceWhat's happeningWhat were you expectingIt's even better if you can provide a screen recording.

Mario Barretta · Answer

Thank you for reply and sorry to not have exposed all better.
next time i'll try to ever follow your list.

1)

Create a bot with a variable text block and a sheet block connected to a google sheet that insert variable in sheet
Create a google sheet with 8 column (1 - 2 - 3 - 4 - 5 - 6 - 7 -8) and inside the second row (C2) put a formula that take data from an other google sheet and insert them in the actual sheet hgere the formula --> (=SE.ERRORE(FILTER('OTHERSHEET'!D:I; 'OTHERSHEET'!B:B = $B$2; 'OTHERSHEET'!A:A = $A$2; 'OTHERSHEET'!C:C = "Colazione"); ""))
Insert a value on variable text block

2

happen that the variable inserted with the bot is positioned on the third row C3

3

I expect that the variable is inserted on B2 and not B3
i expect that also A2 will be populated with data and not A3

I know that's a little complicated to explain and to test but it seems that a cell with a formula has been recognized how with a data inside so typebot insert data on the next row but it's so strange and not correct

Baptiste · Answer

Sorry but any chance you could record a screen recording to clearly show the issue?

Mario Barretta · Answer

Hi I will try to do something but It's too complex to record and to expose.Look like that formulas take a row also if empty.Thank you

Share feedback, ideas and get community help

How to Insert in Google Sheet when a row has formulas