Form + Checklist

[Jeff_Hager]

I would check out this post to see how I’m using a joined list column to build a list from selections in another inline list. You could probably do something similar and save the joined list to another column. You will probably have to create a custom form with user specific columns as temporary placeholders as I don’t believe it would be easy to do in a native form.

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…