How to Automatically Check a Checkbox When Required Conditions Are Met in Coda

I have 3 different check boxes, Admin Review Done, Finance Review Done and Legal Review Done. There is another multi-selection box called Types of Review Needed that can contain one or all of 3 options (Admin Review, Finance Review, & Legal Review). I need it so that after all the required check boxes are selected. The check box for Review Process Done is checked automatically. How do I do this with automation rules or a formula?

1 Like

I would do it with a formula. Probably there are more elegant ways to pull this out, but this is how I often do it.

2 Likes

@Pablo_DV Your solution works, but I find it a bit hard to read.
Like almost always with Coda, there are many ways to solve a problem. This ons is not as easy as it seems, but like Pablo shows, it can be done with a formula.

My solution also works:

3 Likes

Sorry, I didn’t reply sooner to this, but thank you for this. It really helped.

1 Like