Skip to main content

Total in colums and send email

  • January 26, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img

 hi !! can someone help me? i need to send a email dayli, a greed whit total sales in determinate date, how i  can  get a total for each colums, and send in the email ? . 

1 reply

Greg_F
Forum|alt.badge.img+16
  • Inspiring
  • 141 replies
  • January 27, 2023

One possible option would be to create  a table called Totals, and have there  a row that would sum up all items you want. This means:

  • create link in the Totals table to table on your image.
  • Link to all items that should be in the summary
  • Add a Rollup column Total 1 that Totals table using SUM formula inside rollup 
  • do the same for Total 2
  • Send out email using data from Totals table.

Reply