Help

Sum my monthly duration

Topic Labels: Automations Data Formulas
569 1
cancel
Showing results for 
Search instead for 
Did you mean: 
TSE-619
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
gady
4 - Data Explorer
4 - Data Explorer

 

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

YEAR(date)&MONTH(date)

Then create a new grid view group by month
Vewry similar to what is described in
 https://support.airtable.com/docs/finding-the-sum-of-an-entire-field