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
planned
Hi all - we're starting to scope this work, and will be starting with supporting text/string-based variables/fields in Formulas, including Dropdowns, Status, etc. Stay tuned for more here!
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)
S
Shannon Kiefer
So glad to see this is Planned! We desperately need formulas that use other fields - especially Rollups, checkboxes (if checked, then assign a # value), dropdowns (if option A, then assign a # value), and tags (each tag gets assigned a # value and all tags added together)
Arnoud Post
Caroline Ginty awesome! hopefully we can then create clickable URLs based on custom fields 😇
Jonatas Terceiro
Great ClickUp !
Load More
→