Custom field using formula
complete
Truc Thi Thanh Tran
We would like to create a custom field that can sum up the points from other custom fields as example:
where the custom field is named:
PriorityScore (max of 100 points) = Goal + Priority + Size + EndDate + Status fields
Each of the custom fields has different score based on the priority set for them as showed in the image attached.
I can discuss further the request on what I would like to do.
Thanks,
Carolyn
Log In
Caroline Ginty
complete
Henrik Hjort is correct; this functionality is supported via our existing Formula Custom Field. If you want to use a Dropdown field in a Formula, you may do so as long as all the available options for your Dropdown are numbers. Thanks!
Henrik Hjort
This issue should be closed as it can be solved with the customfield type: Formula. Just use the advanced editor and make sure none of the dropdown fields have text values.
C
Carolyn Tran
Hello, I had reviewed the article.. My problem is the following it is to calculate multiple fields together, where each field is a drop down option where point are set to based on the user choose the option.
For example if the user chose the following fields
Goal: Company Goal = 5 points
Priority: Highest = 20 points
Size: Large = 15 points
EndDate: Current Week: 20 points
Status: Red: 20 points
So based on the conditions above, the priorityscore formula would take all these options of each fields and calculate the final value to be
PriorityScore = 5 (Goal) + 20 (Priority) + 15 (Size) + 20 (EndDate) + 20 (Status) = 80 points
I would need to create a script to do something similar I had done in JIRA, https://community.atlassian.com/t5/Jira-Software-questions/Need-scripted-custom-fields-to-calculate-sum-up-based-on-other/qaq-p/2338128
Thanks,
Carolyn
Caroline Ginty
Hi Truc Thi Thanh Tran and voters - have you explored using a Formula Custom Field for this? Here's more information! https://help.clickup.com/hc/en-us/articles/6308656424983-Calculate-using-Formula-Fields