Best Of

Hi,

To add onto all the great information that Kelly provided, I used a "HAS" formula to ensure that all cells with "Active" were counted, even if another word was also in the same cell as opposed to counting cells that only had the word "Active" in them.

Also keep in mind that when you manually insert your Sheet reference, you should select the entire column by clicking the header, to ensure that all rows are captured as new data is entered...assuming you want the full column of data and not a small portion.

Range 1 should be the Division column, and Range 2 should be the Status column in your reference sheet.

=COUNTIFS({Certified Sheet Roster Range 1}, "Eastern", {Certified Sheet Roster Range 2}, HAS(@cell, "Active"))

Try adding a HAS to the MIN/COLLECT.

MIN(COLLECT({Initiative Plan | Start Date}, {Initiative Plan | Assigned To}, HAS(@cell, [Smartsheet Contact]@row)))