How to count inventory used per day in Gantt chart



I have a Gantt chart that has inventory requests by location. I am trying to find a way to use the COUNTIFS function to count how much inventory is out on location on any given day.

What is the best way to do this?

I have been trying to use the Sheet Summary but not having much luck.

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!