Help

Sum time per month and use it as an trigger or automation

Topic Labels: Automations
Solved
Jump to Solution
1453 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Blinkt_Uit
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi!

With our team we use Airtable for a lot of useful practices and one of them is time tracking. My question is about how to trigger an automated message when a single person writes more than for example 10 hours on a customer in a certain month.

image

My (un)logical idea start was. To sum the time per month in a formula column. But i have no clue what kind of formula I need.

Does anybody has an idea?

Many thanks in advance!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Blinkt_Uit! :grinning_face_with_big_eyes: When Airtable executes a formula in a given cell, that formula only has access to other data in the same record (row). It’s not possible to use a formula in that sense to sum numbers from the same field (column).

What you could do, however, is link each entry to a customer record, and do the calculation in the customer record using a rollup field using the SUM(values) aggregation formula.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Blinkt_Uit! :grinning_face_with_big_eyes: When Airtable executes a formula in a given cell, that formula only has access to other data in the same record (row). It’s not possible to use a formula in that sense to sum numbers from the same field (column).

What you could do, however, is link each entry to a customer record, and do the calculation in the customer record using a rollup field using the SUM(values) aggregation formula.

Hi Justin,
A little late response from my end, but thanks! it helped working out a solution.

Greetings