How to Reset Multiple Rows Without Using Updates or Triggers?

[Jeff_Hager]

Reset Multiple Rows - copyable template

Just adding this as a resource that can be linked to. The below template demonstrates the basic technique that was described by @Jeff_Hager in this thread. The concept Apps in that thread are all legacy Apps which cannot be copied.

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…