Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Would it be possible to sum-by-column in automation, or email a pivot table app view?

Topic Labels: Automations
226 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi

There is a table that contains member IDs and credits allocated, which I would like to periodically summarize and distribute to a member of staff. I wish to sum the member IDs duplicated across multiple days, with different credit values, resulting in:
A. Smith 23
B. Jones 12
C. Young 75

It is possible to create this output with a pivot table, but I need to be able to distribute it automatically, without a staff member’s knowledge. While I can send regular email/Slack outputs, I cannot get the summary to work (perhaps with scripting).

Any suggestions?
Thanks!!!
Best Regards
Jessica Layson

1 Reply 1

Hi Jessica
Yes, you will need to have a formula or rollups to calculate the credits. Then you can automate sending that result in an email.

Not sure what your data looks like. Are People and Credits in different tables and Linked or are People, Credits and Dates all in the same table?