Clear Multiple Rows / Columns

[Danny_Nielsen]

Hi, i know this has been asked many times. Just wanted to check if there are any “new smarter ways” to edit (in my case clear) multible rows via actions?

If not, i’ll use API.

[Darren_Murphy]

Not yet, but perhaps in the not too distant future.

[Danny_Nielsen]

Oh, a challenge: the rows i wish to clear / edit are user-specific. Any way to do this via API?

[Darren_Murphy]

No, you can’t do that via the API.

The only way to do that is by using the approach described below:

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…