Creating a Daily Total Sheet from another Sheet that Updates Daily


Hi all,

I am having trouble finding the best practice for this and thought it might be easier to ask here.

I have my "Main Data" sheet that gets replaced daily through a Data Shuttle workflow.

I need to create a helper sheet that totals the count of one of the columns and keeps track of the totals for each day. For example, the totals for each day last week would be on this "Daily Total" sheet and each new entry comes from the main data sheet.

This needs to be accomplished without saving a copy of each days "Main Data" sheet as it is pretty large (100k rows +/-). I am also close to maxed out on Data Shuttle workflows so another workflow is not an option.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!