Clear entire column

[Todd_Lichtenwalter]

I want to clear an entire number column. I set a button to have an action to clear the column but only the first row is being cleared. What am I doing wrong/what is the proper way to make this work?

Thanks
Todd

[gvalero]

Unfortunately, make this is not possible so far. Your plan B is via a GS script.

A Set Column Action only works with a simple relation and you (we) need to use a multiple relation to get it. It has been a desired feature request for a long time.

Saludos Tood!

[Darren_Murphy]

Here is an alternative approach that you might be able to use.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

[Todd_Lichtenwalter]

Great information, thank you!

[Todd_Lichtenwalter]

Excellent, thank you!