Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Sum of status

69 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! 
Does anyone know if there is a way to do a sum of each status?

For instance I have 5 status

Status 1 - 14

Status 2 - 29

I am trying to get a view or a script to be able to automate an email that shows how many items are in each status. 
thank you!!!

1 Reply 1

The easiest way to deal with this is to link all of your records to a single record in another table, and use a "Count" field I think:   

Screenshot 2023-01-07 at 2.47.26 PM.png

Screenshot 2023-01-07 at 2.47.19 PM.png

Screenshot 2023-01-07 at 2.47.15 PM.png