Checking a box on all rows that meet a certain critera.

C. Ruiz
C. Ruiz ✭✭✭
edited 04/27/23 in Formulas and Functions

Hi, I'm in need of a formula that checks a box if the "Current Status" Column on all matching "Lab" "Number" columns that are marked as "Review Complete".

For example in the screenshot below I have lab number CD722 in 4 different rows. When each of those row's "Current Status" is marked as "Review Complete" I would like there to be another checkbox column that gets marked on each row so that I can set up an automation to move those rows to a new sheet, but only if all CD722 rows are marked as "Review Complete"



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!