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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!