Skip to main content

Summing Date Diff according to annual anniversary

  • October 16, 2024
  • 1 reply
  • 13 views
Z
Forum|alt.badge.img+2

Context:
I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.

Current Status:
I am calculating the duration of the events in the Event Request table, pulling it into the User Info table and summing it to calculate total event duration per user.

Issue:
I want that event duration to reset after passing anniversaries of the user's start date. Any thoughts?

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, perhaps try pulling the User Start Date into the Eent Request table, then create a formula field that checks whether that event is before the current anniversary?  Then update the field that calculates the duration to account for this new formula field and output 0 if it is

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement