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
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
J
Please this feature is key. Looking forward to it. Thank you!
Anthony Lemay
This is really really important!! I need this asap! thank you
Load More
→