Help

Creating Sumifs, two variables, in Aitable

Topic Labels: Base design
1320 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Leonardo_Woelln
4 - Data Explorer
4 - Data Explorer

I want to sum a field with several records {Total days off}, by group {Month/year} and {Name}. I have accomplished this by grouping by {Name} and {Month/year} the result shows in the group bar. I want to use the results of this in another formula calculation, in a different table.

2020-10-07

Can I use the values from the grouping or exist a formula such as Sumifs on Airtable?

2020-10-07 (1)

Thanks!

1 Reply 1
VictoriaPlummer
7 - App Architect
7 - App Architect

I think what you’re looking for will be a rollup in the people table.

To calculate PTO by month, you may want a month table.