Finding Status of duplicate entries



I am a bit stumped by what seems like a pretty straightforward requirement.

I have a huge sheet that tracks the status of a series of documents through review cycles. The documents reference a process name and a batch number, which when combined make a unique entry. Each Group of documents on some occasions use the same material (hence repeats of process name / batch number combo as can be seen in the color coded cells). As new groups are added to the sheet, I would like to identify any of the new duplicates that have the status as "approved" in previous entries.

So in the example below, for the Process "bb" and Batch Number "111", I would like an entry made in the Group 2 & Group 3 notify cell for (concatenate bb111) to show approved. Any suggestions would be appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!