4.1k
Formula Column Calculations
in progress
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
in progress
Hi all! Very excited to let you know that Formula Column Calculations are officially in progress. Really appreciate all the engagement on this FR, and we can't wait to get it in your hands as soon as we can!
A
Alastair Dean
I have just started with ClickUp and like it but was really very surprised when I saw that formula columns can't be totalled. It's such a basic functionality (monday.com can do this) and it is a showstopper for me if I can't easily have this when costing and planning projects. I don't mean to seem too picky but could you please confirm if this will be rolled out in the next week or so otherwise I'll sadly have to go elsewhere.
A
Axely Congress
That is a killer request. I actually would no longer need to pop data into excel if this were the case. This would be a major win.
P
Peter C
Caroline Ginty will Calculations work in "Table view" as well or only in "List view"?
B
B Williams
its unfortunate that this is not rolled out with 3.0. waiting patiently but frustrated as this feature is essential
E
Emily King
Thanks Caroline Ginty, will formula fields also be available to use in automations? As triggers, conditions and actions?
S
Stian Johansen
Emily King: After the column Calc. feature is completed they will look into this. ref: https://clickup.canny.io/feature-requests/p/add-formula-fields-in-automations
RS Sound Ltd
Caroline Ginty I think what is remarkable about this and so many features within ClickUp is that you as a team didn’t foresee the need for this and build in the technology from the start rather than having to “completely change the way” formulas are calculated. It’s hardly a massive conceptual step to think “oh the end user might now want a total of their sub calculations”. It’s like building a car with an accelerator pedal and then coming back and saying “dang, we need to redesign it now as we didn’t realise you wanted it to make the car go faster”.
Caroline Ginty
I replied to a comment below, but wanted to surface this context here as well for anyone who is wondering "what could possibly be taking so long!?"
I know it seems like a very simple feature, but we actually had to completely change the way that we calculate Formulas in the product in order to support this (as well as Grouping, Sorting, and Filtering by Formulas). Along with anything where we are changing calculations, we want to be very thorough in our testing that we aren't introducing bugs and are providing the correct outputs. Attaching a super quick demo from our testing environment using a basic Formula so you can check it out!
We are so excited to get this in your hands - trust that we are moving as quickly as possible while ensuring that we are releasing something that will provide immediate value to you and your teams. Thanks!
C
Cameron Etienne
Caroline Ginty: Thank you for working on this! pumped. I am sure it is more complicated than it seems lol Keep trucking!
D
D King
Caroline Ginty: Awesome!!! Thanks for the update.
Benjamin Homaii
Caroline Ginty: Thank you very much for the thorough explanations!
Michael
Interesting Caroline Ginty. Curious - will Subtasks be able to calculate up to Tasks? For example, I let's say - hypothetically - I have 7 Subtasks with formula calculations, but I want to then represent the totals of those in a Task to then be calculated with other tasks.... is that going to be possible?
J
Julia Celley
Caroline Ginty: Can any particular formula result be referenced by a formula in another column/custom field?
D
Deb Dharmaraj
Caroline Ginty: looks great thank you!!! love the work!!
D
Deb Dharmaraj
Michael: yes this feature will be awesome!
M
Matthew Paisley
Caroline Ginty: thank you for the update
Vincent Cardinal
Caroline Ginty: That's a little mini baby step. We need to be able to USE the result of a Formula CF, in another Formula CF !!!
Perry Wirth
Caroline Ginty: Very interested in this one! I was just building out a list and dashboard where this will be needed to do this function on ClickUp vs Spreadsheets or Coda. Is there an anticipated release date?
Also - will there be ability to use these calculated properties in Dashboards such as pie charts, etc or even within Automations as well?
Caroline Ginty
Perry Wirth: We're working on a release date - for context, we need to backfill all existing Formulas with our new calculation process, and we're currently figuring out how long that will take to complete for all Workspaces. So stay tuned!
The Dashboards and Automations teams both have it on their roadmaps (closer to EOY, I believe, but I don't have exact timelines) to support Formulas!
P
Peter C
Cameron Etienne: Will that work also in Table View, not list?
C
Cameron Etienne
Peter C: I think you may have tagged the wrong person.
𝗚𝗕 𝗣𝗥𝗢®
Joke platform !
If you want to know the result of a "Formula Field" count it manually.
Can't be even added to the Dashboard.
You can track your work, NOT your money
(if you want something more automatized, to not put it manualy every f**g time in it. is not working)
Wasted 1 week of me life !
I
Isabelle
I've been waiting for this feature for 3 years! Time for me to leave Clickup since this still is not implemented.
R
Roi Klein
Caroline Ginty
I can't apply the feature yet, do you need to do something actively in the space or account settings?
Michael
This feature is still "In Progress" Roi Klein, so it will probably be back in "Planned" status come October, then into "Under Review" some time in February, Back into "In Progress" likely May or June 2024, and finally rolled out in "Fall of 2024". So look for varying levels of completion rolling out throughout the middle of 2025 😂🙄😭💀 I crack myself up 😂😂
Caroline Ginty
Roi Klein: The feature is still under development with our team! We'll be looking to release it once internal testing is complete, so stay tuned!
J
Joe Downey
Michael: Click up is like a bad relationship. I promise I'll change! I'm working on it! And years later you wonder why you're still hanging around listening to your partner cry wolf.
Jan Dvořák
Michael: I agree the fluctuation is bad - I just cannot remember this specific feature ever been in progress, AFAIK, it was jumping between Planned and no status.
Michael
Yeah…. That was a joke Jan Dvořák…
Michael
Joe Downey: 😅😅 so
that’s
why I love ClickUp so much 😓🤣Jan Dvořák
Michael: The problem is it is also real...:-(
Lara
Caroline Ginty: can you provide an estimated timeline on this? We already started doing some API integrations to solve this problem and we might finish testing before ClickUp does lol
I
Isabelle
Caroline Ginty: This is taking WAYYYY TOOO long for such a basic feature. Thgere is not workaround apart from manual input (error-prone). I can't even copy/paste the results of the formula columns in another column!!!!
Caroline Ginty
Isabelle: We hear you - I completely understand the frustration that this isn't live yet. I know it seems simple, but we actually had to completely change the way that we calculate Formulas in the product in order to support this (as well as Grouping, Sorting, and Filtering by Formulas) so that we could store the values in the database. Along with anything where we are changing calculations, we want to be very thorough that we aren't introducing bugs and are providing the correct outputs.
I know this is probably more information than you were looking for, but know that we have this functionality in testing now, and will get it out to you all as quickly as humanly possible!
Load More
→