Habit Tracker - clear values for new record/day

[Darren_Murphy]

Given that it’s a reasonably short fixed list, what you could do is create a series of Single Value columns, each targeting a separate row of the Habits table, and then use a series of Set Column Values actions to clear the value in each row via the Single Value columns.

For an alternative approach to the problem, take a look at the 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…