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
Z
Zayar
The oldest request for this feature dates back to 2021. It appears that this feature will not be implemented. Other applications like Notion and Monday have it. How long will it take to make this change? Please stop with these useless AI updates get the basic structure right first.
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.
Load More
→