Can I have a formula rollup formula fields from connected issues?

[Joost Reijnen]

I have a list of problems (problem type) and those have fields and a priority score field. Then I have a list of solutions, with connection field to the problems. Each solution may address one or multiple problems. To rank the solutions, I'd like to roll-up/add-up the values/result of the priority score fields of all linked problems.

Or...is there another way? @Tanguy Crusson 

I can do this manually, of course, but would rather not.

[Tanguy Crusson · Accepted solution]

Hi @Joost Reijnen 👋

Not yet, but that's something that's in our radar (the ability to create "roll-up fields" that let you roll up the value of connected ideas)

[Joost Reijnen]

alright, 'radar', so then I'll need to work around it for next 3 months? 6 months? is in the 'next' or 'later'?

[Joost Reijnen]

(was looking for the 👍 to hit on your reply, so but 👍)

[joachim ramberg]

I have initiatives with connected ideas. I created an automation that summarizes the workload for all ideas connected to the initiative and then updates a field on the initiative. Still testing it but it seems to work, might work for you aswell with some customization.

The step And: Create variable {{workload}} has the smart value {{lookupIssues.customfield_XXXX.sum}} which summarizes a value for all linked issues.