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
benjaminclark
That’s a valid limitation, being able to reference rollup values directly in formulas would really improve flexibility, especially for complex setups like executive family pet relocation india https://pearllemonpets.in/services/executive-family-pet-relocation/ where relational data matters.
Caroline Ginty
Merged in a post:
Usage of rollup fields in calculations
Tim Friedrichs
Usage of relationship / rollup fields in calculations or formulas. Currently this is not possible to keep centralized conversion rates and use them throughout the workspace I would have to add them to each an every single item to use them in a calculation - why can't I use that functionality and have a master list centrally and refer them to all boards and use them there? e.g. USD rate, GBP rate, commissions etc.
T
Tin
Merged in a post:
Include rollup field in formulas
Mickaël B. Farlay
What the tittle says : if there's a rollup custom field, I would like to be able to include it in my formula field.
Ex : I have a list for all of my expenses with relationship columns ; in another list, I have rollup fields to add up all of those expenses, but also customs fields for gains ; I would like to be able to have a formula field, where I can sum up these two fields
K
Kat Hicklin
Adding this feature would be a great asset to the entire community
T
Terri Gonzalez
It would be really helpful if formula fields could use values from rollup fields. Being able to add or calculate totals across related items like contracts, amendments, or rates would save a lot of manual work and make these setups much easier to manage.
J
John Bailey
Please add this feature. It would be incredibly useful to our entire team. Thank you.
K
Keith Byrum
I would like to upvote this feature also
Shahen Halebian
This would help our contract and project management workflows so much. Currently, we have to manually add the values of different types of contracts in 5 lists so that the formulas can use a custom column $ field, instead of adding the values to one list, and linking them through a rollup, and then using a formula to add/subtract the different contract values to find the total contract value. It would save our team countless hours of work on a weekly basis.
So for example, a contract may have an amendment or a CO linked to it. Contracts, amendments, CO's, etc are all recorded on their own list. I've added relationships of amendments and CO's to our Contract list, and a rollup of the values of each. So a contract may have linked an amendment and CO and their values. I want a formula to be able to take the initial contract value and add the value in the rollup field(s) to get a total contract value. This should be an simple option to add to the formula capabilities. Please try!!!!
Erin Walker
This would be amazing. We have clickup set for performance reviews, it would be great to use the roll-up to then average scores for comparison across team members.
A
Alp Aydogdu
i want to be able to store constants as variables for use in formulas etc.
eg. Currency Exchange Rate.
- I created a List called Variables.
- A Variable called PHP to AUD
- Custom Field for Variables as Number
- Created a Relation to Staff Member List
- A Rollup to bring in the Number from the PHP to AUD Relation
PROBLEM HERE
- Cant reference this Rollup in Formula to make the conversion happen.
We need to be able to define Constants that can be referenced Variably.
I'd suggest this feature is implemented separate to Relations and Rollups etc.
I just want to be able to define Global Constants somewhere in ClickUp so that I can reference them anywhere.
Even just getting to the point it isn't working is so cumbersome. Because then we need to make sure that relation is linked for every task before we can rollup. and then even that is buggy.
Just give me Global Constants somewhere in ClickUp so that I can reference them anywhere dynamically.
Load More
→