How to Automatically Flag the Flag Symbol Column
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)
Best Answer
-
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 (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Answers
-
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 (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
-
Thanks for the quick reply, @Kelly Drake! However, the flag is getting marked even if the contact's name is only showing up twice...
-
-
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...
-
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.
-
I think that did the trick! Thank you!
-
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...
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!