Help with formula or automation

[FFSL_GISIT]

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 that can contain one to 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?

[Melanie_Teh]

@FFSL_GISIT

Welcome to the community

For a formula approach, for ReviewProcessDone column, add as formula

SwitchIf(AdminReviewDone=true and FinanceReviewDone=true and LegalReviewDone=true, true) or alternatively, =true for the 3 checkboxes isn’t necessary i.e. SwitchIf(AdminReviewDone and FinanceReviewDone and LegalReviewDone, true) .

I’m not sure where the Types of Review comes into play in all of this / why you’ve mentioned it, but if it needs to have one of those options to be selected for your Review Process Done column, then the formula would be

SwitchIf(AdminReviewDone and FinanceReviewDone and LegalReviewDone and TypesofReview.isNotBlank(), true).

Hopefully this helps you and if not it would, we as a community could better serve you if you shared a demo doc

Guide: How to share your doc with the Coda Community

TL;DR Guide (especially for new Coda-Users): How to share your doc with the Coda Community. Just copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a…

Cheers!

Mel