How can I calculate the total time needed per address based on multiple TRUE/FALSE task columns in Google Sheets?

Questions
, ,
1

:bullseye: What is your goal?

Hi everyone,
I’m working with Make.com and Google Sheets and need some help with aggregating data across two sheets.

Sheet 1 contains 5 columns:

Address (string)

Mowing (TRUE/FALSE)

Hedge Cutting (TRUE/FALSE)

Lawn Care (TRUE/FALSE)

Weed Removal (TRUE/FALSE)

Each row represents a location, and multiple tasks can be TRUE for the same address.

Sheet 2 contains 3 columns:

Task Name (string)

Duration in minutes (number)

Weather dependent (yes/no)

I want to create a new sheet where I calculate the total time required for each address, based on which tasks are marked TRUE in Sheet 1 and matching their durations from Sheet 2.

How can I build this in Make.com?
I’m especially unsure about the best way to map each TRUE task to the correct duration and then sum the durations for each address.

Any guidance, scenarios, or example blueprints would be greatly appreciated!

:thinking: What is the problem & what have you tried?

I dont know how to calculate this one.
I know i have to map somehow the mowing from sheet1 to the duration from sheet 2 for example, add these with other durations if something else is true too.

3

Hey there,

you 100% do not need Make for this. All these calculations can be done natively within the sheet.

The formula is basically something like:

=SUMPRODUCT(–(Sheet1!B2:F2=TRUE), Sheet2!B2:F2)