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!
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 !
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!
R
Ryan Lindsley
Caroline Ginty looking forward to this! I’ve been wanting to set priority state depending on the formula result of two rating fields…
Joe Carroll
Caroline Ginty, not sure if you'd consider this in scope, but it would be most excellent to be able to reference variables/fields from lists to which a task belongs (e.g. to fetch the start or end date of a sprint) as well as from
related
tasks. The latter would be a very powerful addition that would bring calculated fields closer to what's possible with databases in Notion.Steve Aylward
Caroline Ginty would you know roughly how long something like this would take? 1 week, 1 month, 1 year? Sorry to ask but we are desperate for this!
Caroline Ginty
Steve Aylward What specifically are you looking for, variable-wise? We're working on strings/text now, but to do everything in the scope of this feature request will be a larger effort. Thanks!
Steve Aylward
Caroline Ginty specifically IF a specific value is selected in a dropdown
Kim Jackson
This would be AMAZING! We would love to be able to use the task name in a formula field to calculate custom field values, add tags or assign users.
Philippe Feracci
This field would be a game changer for so many aspects :
CRM : having a custom field for first name and surname and bringing them to the task name as concatenate.
REFERENCES : being able to create reference file code such as Concatenate (year of the created task date, "/", departement name, "/", task ID or incremental numbers) and so much more.
If you need any feedback or testing feel free to reach out.
Load More
→