LEllis✭

I was able to set up some very simple automation workflows that are working great! Thanks for pointing me in that direction.

Yes, the logic is: If [Group Responsible] contains A or B, then the task requires two sign offs--one from A/B and another from C. If [Group Responsible] contains group C, then the task requires only group C sign off. Said another way: Group A takes the following sign offs: A and C. Group B takes the following sign offs: B…

Oh, of course, that makes total sense! So I have three checkbox columns to indicate where a group needs to sign off on a task. The number of sign offs is based on the group responsible. Most tasks will have 2 sign offs, but some will have 1. Checking the box indicates sign off is complete. Here is a redacted version of the…

This solution worked for my purposes, but I noticed that if I make the formula into a column formula, I am no longer able to check the checkbox. Are checkboxes only usable as cell formulas?

Wow, this is amazingly simple and appears to do what I need. You have no idea how complicated I was making this! Thank you so much.

That's a great point. Thanks for clarifying!

Hello, thanks for posting this solution. I have a question about it. Why do you need both the Auto and the Row column? The Row column is duplicating what's in the Auto column, so why not reference the Auto column instead? The Auto column will only populate if there is something in that row of cells, so wouldn't the Row…