COUNTIF date is with 365 days


Hey Guys!

i need help with a formula to tally individual staff total absences within that last 365 days

example: For Staff 1 there would be a count of 2 for absences in the last 365 days and for staff 2 there would be 1 absence.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!