RuntimeError 400: INVALID_ARGUMENT - Unable to parse range: 'Form responses 1'!100

What are you trying to achieve?

Trying to fix a bug where I am subtracting 1 from a cell in a google spread sheet

Steps taken so far

Searched the make community for similar errors and tried the suggested solutions.

Screenshots: scenario setup, module configuration, errors



Hi @Anne_Pelgrims , Welcome to the community, if I may ask what’s an example value of the Bulk (I) variable, is it a valid cell value like A1, A2 etc…?

It contains the value 100 at the moment and I want to subtract 1 from it

In this example it would be in cell I2

The Cell ID variable has to be a valid value like I2, if you subtract 1 from Bulk (I) that would result to 99, which isn’t a valid cell ID value, hence the error, In place of the Value calculations like Bulk (I) -1 is still valid, but not for the Cell ID.

Thank you so much…I will make the change and test it out later tonight.
I appreciate your assistance.

1 Like

I tried what you suggested and got the same error. I think the problem is actually how I am using the spreadsheet. Ie. Cell I2 contains the value of 100. I want to subtract 1 from 100 and replace the value in the cell with 99 and so on.

It’s a really simple task but I can’t make it work.

TIA, Anne