Skip to main content
Solved

Formula help? Should be simple

  • January 26, 2024
  • 1 reply
  • 0 views
M
Forum|alt.badge.img+3

Hey there,

I've been trying to achieve the following for a few hours now, but without any luck.

STEP 1: I track the time I spend on a certain activity (# session in minutes column in screenshot)

STEP2:  I also sum up the time I spent across all sessions (# sum minutes column in screenshot)

Question: Right now I have to do step 2 manually. As you can see in the screenshot, I manually add the last session's number of minutes to the existing sum of minutes. I oftentimes forget, and / or make errors.

How can I do STEP2 automatically? I just want a column in which the last sessions' number of minutes gets automatically added to the existing total sum of minutes. 

Do you have ANY idea on how to do this? Seems kind of simple and I'd know how to to this in excel but I can't seem to get this to work in Airtable.

Thanks!

 

Best answer by Dan_Montoya

Hi Martin -- It is easy to get caught up trying to solution a problem as you would in a spreadsheet. Here is how I would do this in Airtable:

Create a new table called Totals

Link each session to the same "Total".

In the Total field add a rollup field (on session minutes) and SUM(values). This will give you the total minutes in your sessions table.

If you want to see that total in your sessions table add a lookup field to the "Totals" column you just added.

 

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

1 reply

Dan_Montoya
Forum|alt.badge.img+17
  • Dan_Montoya
  • Employee
  • 273 replies
  • Answer
  • January 26, 2024

Hi Martin -- It is easy to get caught up trying to solution a problem as you would in a spreadsheet. Here is how I would do this in Airtable:

Create a new table called Totals

Link each session to the same "Total".

In the Total field add a rollup field (on session minutes) and SUM(values). This will give you the total minutes in your sessions table.

If you want to see that total in your sessions table add a lookup field to the "Totals" column you just added.

 

M
1 person likes this
  • M
    Martin_Schweins

Reply


Most helpful members this week

Terms & Conditions