Skip to main content

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

  • May 12, 2022
  • 1 reply
  • 19 views
D

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

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • May 12, 2022

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?

Terms & ConditionsAccessibility statement