Skip to main content
Solved

Reviewing Hours Worked by Week

L
Forum|alt.badge.img+2
  • LydiaB
  • New Participant
  • 2 replies

Hi - 

I have a project management and resource tracker AirTable built. I’d like to be able to look at how many hours someone worked in a previous week. Currently I have a rollup from “time entries” to “team” filtered by a formula within time entries that calculates if a time entry was within the last 7 days. But, leadership would like to review this information on (mostly) Thursdays for the previous calendar week. I’m not able to simply adjust the number of days as leadership may look at this information on a Wednesday or Friday. 

 

Is there a way to calculate this information? 

 

Thanks!

Best answer by Mike_AutomaticN

Hey ​@LydiaB!

I guess you have Staff table, Teams table, and Time Log table (or something similar to that).
My understanding is that leadership is currently reviewing this information from the Teams table/perspective.

Is there any good reason not to review this information from the “time log” table? 

You could have a formula field named Week Number to get WEEK() out of the date of the log, and group by Week Number. You can apply a filter to show whatever week you want.
A slightly more robust solution would be to have a Weeks from Current Week formula which will show for example 1 for last week, 2 for two weeks ago, so on and so forth.

Let me know if you need some help setting this up. I’d be happy to help.

Mike, Consultant @ Automatic Nation

View original
    Did this topic help you find an answer to your question?

    4 replies

    TheTimeSavingCo
    Forum|alt.badge.img+28

    Hmm what if you created a formula field that calculated whether the time log record was from last week?  For example, today’s April 5th for me:

    •  

    You could then create a rollup field that would use that as a condition:

    And I’ve set it up here for you to check out!

    IF(
  WEEKNUM(Date, "Monday") & ' ' & YEAR(Date) = 
  (WEEKNUM(TODAY(), "Monday") - 1)  & ' ' & YEAR(Date),
  'True'
)

     

    Adam, Consultant @ thetimesaving.company
    Mike_AutomaticN
    Forum|alt.badge.img+21

    Hey ​@LydiaB!

    I guess you have Staff table, Teams table, and Time Log table (or something similar to that).
    My understanding is that leadership is currently reviewing this information from the Teams table/perspective.

    Is there any good reason not to review this information from the “time log” table? 

    You could have a formula field named Week Number to get WEEK() out of the date of the log, and group by Week Number. You can apply a filter to show whatever week you want.
    A slightly more robust solution would be to have a Weeks from Current Week formula which will show for example 1 for last week, 2 for two weeks ago, so on and so forth.

    Let me know if you need some help setting this up. I’d be happy to help.

    Mike, Consultant @ Automatic Nation

    mtrebinonixon

    Hi Lydia!

    This can be easily done within the Dashboard interface, without need of creating additional field or formulas, but instead by using filters within the Dashboard interface.

    There you’ll be able to create a bar graph with the worked hours per calendar month, and you’ll be able to apply filters for the date (only last week) and other filters such as collaborator.

    Explore the Dashboard interface (within the Interface section of Airtable) and let us know how it went!

    L
    Forum|alt.badge.img+2
    • LydiaB
    • Author
    • New Participant
    • 2 replies
    • April 7, 2025

    Thanks everyone!

    Reply


    Most helpful members this week

    Terms & Conditions