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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!