COUNTIFS
I am new to Smartsheets and I am attempting to count how many times an individual has traveled in a calendar year. I figured out how to count the individual, but I don't know how to add the date range. Your help is much appreciated!
Best Answers
-
As long as the year doesn't lapse, you could use something like Year(@cell)= 2020.
=COUNTIFS([Last Name]:[Last Name], "Weiler", [First Name]:[First Name], "Myriam", [Return Date]:[Return Date], YEAR(@cell) = 2020)
-
This worked great, thank you! Is there a way to apply this formula to all the names using @row formula?
-
But you'd have to have a new column listing each user in the sheet.
Answers
-
As long as the year doesn't lapse, you could use something like Year(@cell)= 2020.
=COUNTIFS([Last Name]:[Last Name], "Weiler", [First Name]:[First Name], "Myriam", [Return Date]:[Return Date], YEAR(@cell) = 2020)
-
This worked great, thank you! Is there a way to apply this formula to all the names using @row formula?
-
Where are you storing this formula? It looks like you are keeping it in the sheet summary. If you're keeping them in there, no. If you're creating summary data somewhere on the same sheet, then yes, possibly.
-
But you'd have to have a new column listing each user in the sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!