Sum of all click up task that has same custom field

How To
1

Hi Make Community,

I’m new to Make and could use some guidance with building a scenario. Here’s what I’m trying to accomplish:

I have a specific list in ClickUp, and within the “Lead Endorsed” stage, there are multiple tasks. Each task has custom fields with the same names, such as Name, Country, and Campaign Name, but the values in these fields vary between tasks.

I want to count the number of tasks in the “Lead Endorsed” stage that share the same Campaign Name. For example:

  • If 5 tasks have “Campaign101” as the Campaign Name, and
  • 10 tasks have “Campaign202” as the Campaign Name,

The output I need is:

  • Campaign101: 5
  • Campaign202: 10

I also have a Google Sheet where all the campaign names are listed in Column V, and I want to update Column Z in the same row as each campaign name with the corresponding count of tasks from ClickUp.

Would love your suggestions on how to set up this scenario effectively. Thank you in advance for your help!

3

Hey Elias,

you can use the List Filtered Tasks module to get tasks with specific custom field values.