Re: Sum my monthly duration

486 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello, all.

I'm new to Airtable and I need to create a form that tracks how many hours my coaching team is meeting with individuals each month. Each entry would be a new meeting, and I meet with individuals only once each month. Ideally, it would all exist on a single table. 

Each row would need to have the following information: Individual's name, date, duration, coach, Notes. 

Ideally, I would have another column that sums the month's hours as I go, call it "Hours this month".

I assume there should be a formula that can do that for me, but I haven't for the life of me been able to utilize my Excel knowledge to create a working formula for AT.

Any recommendations or alternatives to how I can approach this?

1 Reply 1
4 - Data Explorer
4 - Data Explorer


You'll need to create a new function field called month i.e. 


Then create a new grid view group by month
Vewry similar to what is described in