Use "set column" to clear all values in a column?

[ihackstuff]

I have a boolean column, and I only display “unchecked” items. A user “checks” the box in the checklist to clear the item from view. Can I use “Set column” in some way to clear every boolean in that column and bring all the items “back”?

Thank you!

[Jeff_Hager]

You can’t set a value on multiple rows at once without using google scripts.

I’d recommend checking out how I do it here. I don’t think it will work with a checklist layout, but with some emojis or images, you can achieve the same result.

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…