Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to add timesheet entries to correct month

715 5
Showing results for 
Search instead for 
Did you mean: 

Hi all,
I’m not sure if this can be done at all but I’d like to work out a way to add timesheet entries to the appropriate month.

I currently receive timesheets with a week commencing date and then hours for Monday through to Sunday. I have defined which month each day of the week falls into with a formula - see screenshot:

I would now like to run a report that adds up all hours worked on any project and in any given month but I can only come up with a report that rolls up the totals in two columns which doesn’t help.

What I’ve got:

What I’d like to have:

Not sure if I’m just looking at this from the wrong angle but I can’t figure out any way to make this work and would appreciate any help on this.

Thanks a ton.

5 Replies 5


I’ve read through your request and have a solution in mind. Would you be able to chat further via free phone consultation to discuss this project in detail so I can provide a price and turn around time?

Schedule a free phone consultation via this link:

To learn a little more about myself, please visit my website:

If you’d like to connect with me on LinkedIn, please do so here:

I look forward to hearing form you!


Hi Eric,

Sure - are you available tomorrow for a call?

@nadja_stanglauer, I sure am! Please select a time that works best for you via this link:

What you are wanting to achieve is definitely well within my area of expertise and I would be glad to help you out on it.
You can reach me on
Best Wishes,


Please check PM.

Jennifer J