Help

Timesheet function to show available hours from each "week" as running total

Topic Labels: Data Formulas
305 0
cancel
Showing results for 
Search instead for 
Did you mean: 
caitlingubert
4 - Data Explorer
4 - Data Explorer

Hi all -

I have a table that acts as a timesheet for the same users to submit hours each week.

I use the 'Hours Logged' from Fig. 1 (which is an entry for that week) and add it as a lookup value to my table with my people names (Fig. 2). There's multiple entries in the Hours Logged in Fig. 2 as it should, but when I go to my main table, it doesn't show the 'Hours Logged Sum' for that week. Instead, it shows it based on all entries. Is there a way so that I can get the 'Hours Logged Sum' to show what the sum would be for that week like a running sum for each individual? 

As an example, how would I show that the hours logged sum would be: 

Hours logged = 3.0; Hours Logged Sum = 3.0; Max Hours = 40; Hours available = 37

Hours logged = 1.0; Hours Logged Sum = 4.0; Max Hours = 40; Hours available = 36

Hours logged = 5.0; Hours Logged Sum = 9.0; Max Hours = 40; Hours available = 31

Fig. 1

caitlingubert_0-1702656791321.png

 

Fig. 2

caitlingubert_0-1702656371915.png

^ Shows the running sum here, but it adds them altogether for every entry that matches the lookup. 

 

 

0 Replies 0