Im trying to create a table in Airtable that would auto-populate some totals from other tables in the same base. Basically, I want to see what the sum of a total is in a specific view in a separate table.
I have a field labeled “Total Words” and the sum of those numbers changes depending on the view. I know how to do this in Excel, I would create a SUMIF formula.
I want the cell to display the sum based upon if a record is categorized as “Ready to Post”, “In Progress”, or “Needs Assigned”.
I can’t figure out if this is possible. Please help!