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
Francesca Angemi
Rollup fields too please🙏
Mario Rader
Is there a timeline on this feature yet?
This would be great – my use case is, that I use "My Dropdown" with options like …
1 – none
2 – some
3 – many
… and I would like to use the first character in a formula to calculate a score; seems as if all the gears are already in place – LEFT(field("My Dropdown"), 1) * 1) – but it won't let me use field("My Dropdown") in the formula, unless all the option values are numeric.
Silke Turner
Is there an update on the timeline for this? Again, this is where it's hard to justify ClickUp to Executive when Notion has so much formula functionality and is about to introduce granular database permissions; especially when ClickUp doesn't allow estimated and tracked hours to be converted to dollars by each employee's charge rates via built-in COTS functionality - at least being able to do this via self-built formulas would offer a workaround.
R
Richard Oboh
Can the formula window be much bigger? It is frustrating to be constrained to such a tiny window.
Paddy Robinson-Griffin
if(fields("some checkbox"),true, false) would be super useful
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.
Load More
→