How to count inventory used per day in Gantt chart

Hello,

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!