Formula help: Same criteria, same date, multiple rows
I feel like I'm missing something obvious here, but I'm struggling to come up with the correct formula to accomplish a task. Multiple attempts have come up empty.
What I'd like to do is: When there are more than one instance of the Distribution column displaying 4 stars on the same day, I'd like the checkbox in the Status column to be checked -- for only the rows with 4 stars.
I've manually done that in the example below, but I'm trying to drive that by a formula.
Any ideas?
Best Answer
-
The below formula should do it for you
=IF(AND(COUNTIFS(Distribution:Distribution, "Four", Date:Date, Date@row) > 1, Distribution@row = "Four"), 1, 0)
Answers
-
The below formula should do it for you
=IF(AND(COUNTIFS(Distribution:Distribution, "Four", Date:Date, Date@row) > 1, Distribution@row = "Four"), 1, 0)
-
Perfect. Thank you so much for the help. You nailed it. Appreciate the help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!