Formula Column Calculations
complete
J
Josh Udell
It would be very nice for the Formula columns to be able to calculate at the bottom like other columns do.
Log In
Caroline Ginty
complete
Formula column calculations are now live for all Workspaces! Documentation is live in our Help Center here: https://help.clickup.com/hc/en-us/articles/6308656424983-Calculate-using-Formula-Fields#h_01HG9DJGE561HQNA3FQG9YEG66 Thank you for all the beta feedback throughout the development process!
E
Evan Olson
Does this not work if you use the TODAY() function in the formula?
Caroline Ginty
Merged in a post:
calulate field with a formula
laurent lourenco
Currently it's possible to sum up a numeric field in list view, and to see the total at the botton of the list (or the range or the average). but unfortunately it's not possible with a field which is a formula. For example One field is "time estimate", one filed is "time tracked", one formula field is "time left" = MAX(0, field("time estimate") - field("time tracked")) . I would like to see the total of "time left" at the bottom of my list.
J
Jeff
it doesnt calculate the column immidiately, ive to refresh the pages or the software to make the right calculation appear.....
hope to upgrade it further.
thank you so much
Caroline Ginty
Merged in a post:
Have the sum of formula type fields
Nadine Koriolis
I neeeed the total of the formulas column (wich could be different than the same formula applied to the total of used fields in the formula)
R
Rebecca Smith
Yay! Finally!
Jay Dave
This is a common sense. I don't know why ClickUp never though about this feature.
Caroline Ginty
complete
Formula column calculations are now live for all Workspaces! Documentation is live in our Help Center here: https://help.clickup.com/hc/en-us/articles/6308656424983-Calculate-using-Formula-Fields#h_01HG9DJGE561HQNA3FQG9YEG66 Thank you for all the beta feedback throughout the development process!
Aimee Mason
Caroline Ginty: Hi Caroline. Not seeing it, anything special needed to have it take effect?
Caroline Ginty
Aimee Mason: Nothing special should be required - have you tried giving it a quick refresh?
Aimee Mason
Caroline Ginty: Yep. It's a dollar amount $ derived by multiplying the time estimate by hourly rate. Advanced formula is "$"&(field("Time estimated in hours")*150) -- any reason that wouldn't be able to be calculated as a sum?
Amara Amzal
Caroline Ginty: Hi, the next urgent step is undoubtedly to make custom formula fields available in Dashboards (https://clickup.canny.io/feature-requests/p/formula-fields-in-dashboard).
Caroline Ginty
Aimee Mason: It's because you are appending the $, which means it's being read as text rather than a number, which is a known limitation right now. We'll be working to fix this, but if you remove the $ for now, it should work!
Alternatively, you could create a dummy Money field populated with the $150 for each task (& could hide it on the view to avoid clutter), and use that in your Formula, and it should work correctly.
Aimee Mason
Caroline Ginty: Makes sense! Thank you
Courtney Hernandez
Caroline Ginty: can you double check my company's workspace. Nothing seems to be happening on my end. I cleared cache/cookies as well just in case.
Caroline Ginty
Courtney Hernandez: It's the same issue Aimee was running into above; because you are appending an 'h' to your Formula value, the field is being read as a text output rather than a number output, which can't be summed. If you remove the appended 'h', you should see the option appear while we are working to better support this. Thanks!
Courtney Hernandez
Caroline Ginty: I thought that was the case. In the video it shows me removing the "h" and it did not work still?
C
Crystal Dunn
Caroline Ginty - will the 'days' formula be evaluated to be able to be calculated as well? Assuming it is included in the same limitations as the text fields you mentioned are.
Michael Montefusco
Hey Caroline Ginty, will we get a special notification if it is in our account? And is there any docs on the new capabilities so we know what we can experiment with?
Thanks so much!
Caroline Ginty
Michael Montefusco: It should be released to everyone later today! Here is the documentation in our Help Center: https://help.clickup.com/hc/en-us/articles/6308656424983-Calculate-using-Formula-Fields#h_01HG9DJGE561HQNA3FQG9YEG66
Jay Dave
Hi,
I have a calculation column that auto calculates as a Total Cost. I don't see this calculated at the bottom of my column. This is a common sense. I'm not sure why you wouldn't include this feature.
I also want to use this total calculated amount at the end of each column as a graph in my Dashboard. See the attached screenshot for more detail.
Thanks
Jay Dave
This is a common sense to add a Calculate option for the formula column. I don't know why ClickUp doesn't allow this.
William Fielding
Thanks for the update Caroline,
Does this include being able to use the results from a formula field, within another formula field?
e.g. Field D (fx) = Sum of Field A (#), Field B (#), Field C (#) = 100
Field X (fx)= Sum of Field D (fx), Field E (#)
Caroline Ginty
William Fielding: This is a separate feature request here: https://clickup.canny.io/feature-requests/p/use-a-formula-field-in-another-formula-field, but one we hope to start work on soon.
Load More
→