COUNTIFS

Myriam Weiler

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!

Mike Wilday

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)

Myriam Weiler

This worked great, thank you! Is there a way to apply this formula to all the names using @row formula?

Mike Wilday

But you'd have to have a new column listing each user in the sheet.

Mike Wilday

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)

Myriam Weiler

This worked great, thank you! Is there a way to apply this formula to all the names using @row formula?

Mike Wilday

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.

Mike Wilday

But you'd have to have a new column listing each user in the sheet.