Use any (standard/custom) field in formulas (not just number and date fields)
planned
Galen King
It appears it is only possible to reference numeric or date fields in formulas. I would love to be able to do something like if(field("Status") == "Urgent",2,1) in a formula field. Is that not possible?
Log In
Caroline Ginty
Hi all - trying something a little different here and looking for volunteers who want to alpha test text variables in Formulas (currently short and long text Custom Fields only!) in their Workspace. We have a proof-of-concept for this working, but want to try it out with some real use cases to get feedback and help us identify any additional bugs. Note that I'm very purposefully calling this an alpha, as we fully expect there to be some remaining issues we'll need to address.
If that sounds like something you would be interested in, please fill out this form for early access: https://dev-forms.clickup.com/333/f/ad-1716329/97D1T0TWCV394T7F9Q. You will receive an email when it is enabled for your Workspace.
Submit any/all feedback and bugs here: https://dev-forms.clickup.com/333/f/ad-1716317/OYUZ4FKH22CKVQGQZM
Thanks in advance for your partnership on this feature!
Paddy Robinson-Griffin
if(fields("some checkbox"),true, false) would be super useful
Caroline Ginty
Hi all - trying something a little different here and looking for volunteers who want to alpha test text variables in Formulas (currently short and long text Custom Fields only!) in their Workspace. We have a proof-of-concept for this working, but want to try it out with some real use cases to get feedback and help us identify any additional bugs. Note that I'm very purposefully calling this an alpha, as we fully expect there to be some remaining issues we'll need to address.
If that sounds like something you would be interested in, please fill out this form for early access: https://dev-forms.clickup.com/333/f/ad-1716329/97D1T0TWCV394T7F9Q. You will receive an email when it is enabled for your Workspace.
Submit any/all feedback and bugs here: https://dev-forms.clickup.com/333/f/ad-1716317/OYUZ4FKH22CKVQGQZM
Thanks in advance for your partnership on this feature!
자미 (SO)
Caroline Ginty hi there! Is it possible to have a formula for counting function 'related tasks' in this alpha test?
Caroline Ginty
자미 (SO): Not yet, but we'll get there! This alpha test will only support short and long text fields as variables. Thanks!
Daniel Høiberg Lambrecht
Would be great to be able to use custom date fields as triggers as well!
A
Alex M.
it would be really awesome being able to do stuff with formulas based on assigned /subjective "Priority", even if found un-set.
k
kris Zentek
Any update on when this is going to be ready? I have a need to add WSjF scores to Clickup tickets, and so I need to be able to create a formula field (the score) based on the inputs from other custom dropdown numerical fields.
Stojadin Nicic
This feature is indeed necessary. Hope that it will be updated soon :)
Guy Mannerings
While this is being worked on, could you also please fix the bug/change that occurred maybe 2 months ago that changed how Formula Fields respond to a Due Date field that is empty?
Previously, if a reference was made to an empty Due Date field, it would just leave the Formula Field blank (or maybe it had a "-" ).
Now, it throws up an error saying "invalid input for field type", and makes the box red.
This has broken a "Days until due" Formula Field I made, which calculated the days between TODAY and the Due Date:-
DAYS(field("Due date"),TODAY())
Because now Tasks that don't have a Due Date set have a big red error box in this field instead of just being blank.
I also can't get any workaround formula working where it would respond with a "-" if the Due Date is empty.
I told support a long time ago, who said it was an intended change at one point, and a bug at another point. Either way, it's been outstanding for a while, and is not a great change when there is no workaround.
Jenni Skarsten
Caroline Ginty - will this include rating fields? (Equating to numbers 1-5)
Leo Bastian
Just wanted to use a rating field for a 5 Dysfunction of a Teams Assessment using a Clickup Form, the final values are supposed to be calculated in a formula field, so apparently until this feature isn't there, I have to annoy users with a dropdown field :|
Paul Stoute
Since this is already planned, it would be amazing if we can utilize the relationship count in the formula.
Example: I have a list for "servers" and a list for "sites". I need to be able to use the relationship to get a count of the number of sites on each server.
While we already have the relationship and can display the "count" I have to add a second number field and manually update the "sites on server" count in order to utilize the count in a formula.
So we have 2 fields that say the same thing just to be able to use the site count in the formula.
Simple formula: field("sites allowed") - field("sites on server")
If formula: if(field("sites on server") > field("sites allowed"), FALSE, TRUE)
Load More
→