COUNTIFS FORMULA
Can anyone help where the error to this formula is please?
Just trying to count if a date appears in one column and a color appears in another. Should be easy right?
=COUNTIFS(({Range DATE CREATED}, DATE@row),{Range Colour}, "RED")
Best Answer
-
Hello @Ed Gadd,
It looks like you have an extra parentheses around the first criteria set. Try this:
=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Answers
-
Hello @Ed Gadd,
It looks like you have an extra parentheses around the first criteria set. Try this:
=COUNTIFS({Range DATE CREATED}, DATE@row, {Range Colour}, "RED")
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
-
Works perfectly, thank you so much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!