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
Check out the Formula Handbook template!