How to update cell values of a Column in Google Sheet

Help Studio
, , , , , , ,
1

Hello everyone,

We need to change the value of range A2:A5 and set the value as 10

How can we provide this range in Google sheet Write cell. As its not accepting range format

Thanks in advance:)

2

Hi @anmita

Write cell activity can’t be used to update range of cell, it used to update single cell value. You can use write cell activity to update A2 and A3 cell and Auto Fill Range activity to update remaining cell.

Or
Keep the cell value in array. Loop through each cell value using for each and use write cell activity to update the cell value.

Hope this helps

3

@anmita

Write cell by nature is used to write into one single cell…

If you need to write data into multiple cells then you need to use write cell in a loop or use write range a tivity accordingly

Hope this helps

Cheers

1 Like
4

Hi @anmita,

This article might help you.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.