How to Automatically Flag the Flag Symbol Column

tylermh

I'm looking for an IF/COUNTIF formula for automatically flagging the flag symbol column when a contact's name appears in a Contact column for a 3rd time? (incident tracking report)

Kelly Drake

Hey Tyler - sounds like htis would work...

=IF(COUNT([Contractor Name]:[Contractor Name], [Contractor Name]@row) <=3, 1, 0)

This would flag the flag cell for all of them when the contractor is listed 3 or more times....

Kelly Drake

Hey Tyler - sounds like htis would work...

=IF(COUNT([Contractor Name]:[Contractor Name], [Contractor Name]@row) <=3, 1, 0)

This would flag the flag cell for all of them when the contractor is listed 3 or more times....

tylermh

Thanks for the quick reply, @Kelly Drake! However, the flag is getting marked even if the contact's name is only showing up twice...

David Joyeuse

Hi @tylermh

I would suggest you to use ">=3" instead of "<=3"

Probably a typo from Kelly.

tylermh

Thanks @David Joyeuse, I think we're getting closer, but as you can see below, the formula is not taking into account that I only want it to flag the name(s) that has shown up 3 times or more. The way it's working now is the flag turns on no matter what name is being counted...

David Joyeuse

Try to replace COUNT by COUNTI, with everything else the same way.

It's probably what Kelly meant first, because looking at her formula, using COUNT here doesn't seem appropriate.

tylermh

I think that did the trick! Thank you!

Kelly Drake

Sorry about those typos! Yep on the COUNTIF and my math teachers would be so sad panda that I messed up the greater than/less than...