Is there a formula to pull each day's final numbers into a metrics sheet?


I have created a tracking sheet for our supervisors to provide the number of transactions per category at the end of each day. I would like to roll this information into a dashboard for easy daily reporting to executive leadership but I'm having trouble with pulling only the day's information (from the most recent work day). For example, our daily report reads like this:

And I have a metrics sheet:

But I would only want the metrics from the most recent date (in the first example it would be for May 12). What would be the easiest way to collect only the most recent workday's numbers?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!