IF/COLLECT? Report?

Options

Hello,

I'm at a loss as to how to solve my problem here.

I have a sheet that contains multiple rows that are identical except for the person they are assigned to (Instructor) and if the Confirmed box is checked or not. See example.

I'm thinking of these as groups of rows. For each group I only want to confirm one row from the group to one person. This has been a manual process.

I'd like a formula (or maybe a report is better?) to evaluate if I've missed confirming any of the groups of rows. My thought process is that the formula should first identify if the row belongs to a group and then if there is a Confirmed box checked within that group. No idea how to go about this.

Any ideas?

Hannah


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!