Creating a Daily Total Sheet from another Sheet that Updates Daily

Christopher.Ontkean

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.

Paul Newcome

I would set up another sheet that is the same as the one with the totals. Then you can set up a Copy Row automation to copy the daily totals to this new sheet every day before the the data shuttle refreshes the main sheet.