Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Sum my monthly duration

Topic Labels: Automations Data Formulas
1041 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