COUNTIFS with date referencing a date range


Hey all,

I have a time off tracker for our installers and their skillset is either level 1,2,3 (picture 1). I need a way to show who is taking off in reference to the date column by level (picture 2) but not sure how to build this formula with a date range. Also, I have it set where if they request one day off, the "End Time Off" will be blank.(pic 1)

Current formula in "Level 1 off" (picture 2) column is below:

=COUNTIFS({Level}, "1", {start time}, Date@row)

The formula above will only show that one date but not sure how to show if they take off 8 days for example without building out multiple helper columns. Any help would be great!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!