Better Formula Ability
not on the roadmap
M
Miriam Magid
Make the formulas easier to use and much more robust - basically just copy GSheets! If it wasn't for the formulas difficulty and limitation, ClickUp would be able to replace most of my spreadsheets!
Log In
Caroline Ginty
not on the roadmap
Hi all - I'm closing out this high level task in favor of the individual feature requests that we have for Formulas. Please upvote and add comments to the individual requests so that we make sure all the relevant feedback is captured in one place!
M
Melanie von Schorlemer
Yes, make it possible to replace spreadsheets and make formulas easier to create.
Gail Fraser
Would LOVE to be able to report on formula fields in dashboard bar charts!!
K
Kay Dewar
Can we also have the ability to change format - so when doing a calculation aiming to see a % we're able to update the format to match
Max Klimenko
+ Use variables from all related lists task fields
Caroline Ginty
Hi Miriam Magid - I'd love to know more about the specific gaps you'd like to see us solve with Formulas in ClickUp! We are currently working on a slew of enhancements to Formulas, so feel free to share specifics on what you'd like to see!
Vincent Cardinal
Caroline Ginty: First and foremost. The data generated by a formula CF has to be usable in another formula CF. So we could do some real budgetting. Time X Cost/time = X$ ... then use : X$ X 1.4 = Billable$ . Also The vertical sum (Calculate) button at the moment has to be accessible to a Formula CF. This will let us use CF formulas like "Excel". Budgetting is the missing link to so many of us . Using "make" (integromat) to send data from CU to Google sheet is not usable ... it's slow and painfull. Using the Formulas in CU has to be the solution !
Caroline Ginty
Vincent Cardinal: Thanks! We are working on both of these items right now, column calculations will be available very soon, and then formulas in formulas sometime after that.
Vincent Cardinal
Caroline Ginty: that's is absolutely great news! Thanks so much for the heads up. I'll be a beta tester with no hesitation!
S
Salvatore Cipollaro
Caroline Ginty consider adding support for if-then-else conditional logic alongside the existing if-then.
Roger Spalding
Caroline Ginty: Lovely to hear! Make the formula UI more simple like Google Sheets would be awesome and expand the formulas types as well
Cassie-Ann Sam
Caroline Ginty: can we also see results from formula custom field in dashboard cards?