Make rollups from relationships available for formula fields
R
Rodd Myers
It doesn't seem there is a way to add the values for a rollup field. It would be great to be able to use rollup field values from relationships in formula fields.
Log In
Cody Stewart
We need this!
Rollup fields need to be available for the parent task's formula fields and for ClickUp AI to use.
Our SEO reporting is hindered by having to pipe in all the data into a single task and have hundreds of custom fields to store it all instead of having related tasks for each channel like Google Search Console and Google Analytics.
ClickUp formula fields and AI need to be able to access related data through rollup fields so we can connect our data contextually throughout the workspace instead of always having to push the same data into multiple tasks.
Sam Woods
Currently this is roadblocking our entire use of ClickUp AI.
Since the relationship fields aren't available in the context of the task it is linked to, formulas are useless as well as AI. Even in the rollups they are useless because the formulas aren't even fetching the data from the task it is used by and throws an error that the variables don't exist.
We want to pull in data from other tasks into a report task and were hoping that rollups would be contextually available to the task they are linked into, but now it appears that it's just a visual addition and in fact has no contextual relationship between the tasks.
B
Bryson Allen
Got to say, I think ClickUp is missing a huge opportunity with the way Relationships are limited right now. There are some major gaps (and many more other frustrating gaps with Relationships, so ill keep this post focused to these):
1)Relationship fields aren’t supported in forms
2)Relationship rollup fields aren’t supported in formula fields
3)Relationship rollup fields aren’t supported in most views (only Lists), and—most critically—not in Dashboards
Because of these limitations, Relationships go from being a potentially game-changing feature to feeling almost useless. Please, stop putting so much focus on AI features and put that energy into strengthening the core architecture. My clients keep running into these issues, and some are ready to leave the platform because of it. They don’t care about AI right now—they just need the fundamentals to work.
Caroline Ginty
Merged in a post:
Allow Rollups columns to be in formulas
A
Amber Caceres
I want to be able to make a formula column that adds values from my rollup columns
Caroline Ginty
Merged in a post:
Possibility to use aggregated fields in formula custom field
C
Cesar Augusto de O. Diniz
Possibility to use aggregated fields from related tasks in formula field
Caroline Ginty
Hi Cesar Augusto de O. Diniz - thanks for reaching out! I assume that by aggregated fields from related tasks, you're referring to Rollups. I'll go ahead and merge this into the existing feature request for this functionality. Cheers!
L
Liam Trampota
My team desperately needs this feature - we will be using notion until then
Mihanta
This is necessary features
Jason Vallina
I've been requesting this feature for several years, and share the sentiment expressed by many others in this thread that the addition of this single feature would revolutionize the utility of this product, far beyond the AI features that seem to be the current priority. As it stands, the omission is terribly frustrating, and in most cases eliminates the value of relational data - if you cannot extract information from those relationships, the relationships have no value. For example, in simple project budget where each item is linked via a relationship to a primary budget category, I can see the total of all the items in a category, but I cannot use that total, like subtract it from the column next to it that contains the total budget for that category. And these use cases pop up everywhere.
Richard Taylor
This is urgently needed, at the moment I have to manually copy the rollup field by hand to another field so it can be used in a calculation - this is very unusable
Load More
→