- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 12, 2022 02:36 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 12, 2022 08:36 AM
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?