Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 07, 2020 07:19 AM
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.
Can I use the values from the grouping or exist a formula such as Sumifs on Airtable?
Thanks!
Oct 12, 2020 11:21 PM
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.