Use a Formula Field in another Formula Field
complete
Karl Heinz Frankeser
I feel link the formula field is really restrictive, I wanted to multiply all values by 5 and could not do that, also why can't I take a number field and add it to a formula field to nest two formula fields into one calculation?
Log In
Caroline Ginty
complete
Hi everyone! I'm thrilled to share that this functionality is now live for all Workspaces! Please check it out and tag me in for any feedback that you have!
Charlie Clarke
Is there a canny for nesting more than 1 level?
Caroline Ginty
complete
Hi everyone! I'm thrilled to share that this functionality is now live for all Workspaces! Please check it out and tag me in for any feedback that you have!
Nick Donovan
Caroline Gintyamazing thank you.
A
Alex Bowsher
Caroline Ginty Tested and working well for our use case. Thank you!
D
Dylan Halliday
Caroline Ginty I did some basic tests and it was buggy?
Field 1: 5-2=3
Field 2: Field 1 + 1 = 6 (should be 4)
Field 3: Field 1 + 2 = 7 (should be 5)
I assume its calculating the first number in the 5-2 formula from field 1, not the result.
Also, why is it restricted to 1 nested level? Is there plans for further depth in the nesting?
Caroline Ginty
Dylan Halliday Please file a ticket with our support team; this is not expected. Thanks!
A
Arabelle Lim
Caroline Ginty, Hi Caroline. Thank you for this new feature. Yes, indeed it is restricted with 1 nested level. It would be really useful to have more than one nested level.
Sally
Caroline Ginty this is still not working in our workspace
Caroline Ginty
Sally Please file a ticket with our support team. Thanks!
Caroline Ginty
Hi all! We have released this to 20% of Workspaces, and plan to ramp up to 100% by EOW. I'll mark this request as complete one it is fully rolled out. Thank you, and let us know what you think!
César Lira
Caroline Ginty Amazing!
Caroline Ginty
Happy Thursday everyone! Excited to share that we have completed testing on Formulas in Formulas. We have identified a couple bugs, which we are actively fixing as we speak. Depending on when those fixes are complete and tested, we will start rolling this out towards the end of next week or the following (week of Aug 12 or 19). Thanks for your patience!
M
Mitch Webster
Caroline Ginty great news. Is there a link to explain what will and won't be supported. I.e. some examples.
Nick Donovan
Caroline GintyHi Caroline, is there any possible way to activate mine now? I am really stuck without being able to achieve this. Lily Chan Got the dashboard to handle formula fields which is great. However, without formula field in another formula field being able to add, subtract, do math with formulas, I am stuck. The shipment of this is 1-2 weeks after I really need it and have been stuck.
J
John Carling
Caroline Ginty this is good news. I'm not sure if its part of this sprint, but where did the team end up with expanding formula fields to look at string values, and/Or 'extension' formula fields on tasks, like IsClosed, IsDone, IsOpen, IsNotCanceled ? These asks were all due being able to compute Weighted Percent Complete.
B
Bec McFarland
Caroline Ginty any news on whether this will work for date formulas?
Charlie Clarke
Is this live yet? I saw a thing saying end of July?
Kayla Gallocher
Eagerly awaiting an update on this one as well. It will enable my team to move to ClickUp almost entirely.
M
Manish Andodariya
Any updates on this? Eagerly waiting for deployment.
C
Caroline Leonard - Operations Manager
Any updates on this? Desperately need to do produce a calculation based on other custom fields that are developed with a formula?
Caroline Ginty
Hi everyone! We have completed development and are starting our internal QA review process to test and confirm everything is working as expected. Barring any issues discovered in testing, we hope to start rolling this out by the end of the month. Thanks!
R
Ryan Lindsley
Caroline Ginty are we getting any improved logic like greater/less than options? If this value, then set other field to that?
Caroline Ginty
Ryan Lindsley Not in scope of this feature, but this IS in the works as part of support for using Formulas in Automations (https://clickup.canny.io/feature-requests/p/add-formula-fields-in-automations)
R
Ryan Lindsley
Caroline Ginty are we getting any improved logic like greater/less than options? If this value, then set other field to that?
H
Hugo Doria
Caroline Ginty that's awesome! Can't wait to try that.
Craig Wallace
Caroline Ginty Will this enable us to use CONCAT to combine two field values?
eg. CONCATENATE('field("Custom Field Value 1")', ' ', 'field("Custom Field Value 2")').
Right now you can only CONCAT certain standard fields.
A
Arabelle Lim
Caroline Ginty When will this feature be available? I am impatiently waiting for it!
R
Ryan Lindsley
Caroline Ginty The one you linked got completed without support for greater/less than logic too... I'd love it in automations, but it'd also be powerful in formula fields too.
Jarod McPherson
Caroline Ginty any update?
Load More
→