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!



Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!