Use any field in formulas, e.g. dropdowns and text (not just number and date fields)
considering
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
marked this post as
considering
Update Nov 2025: This feature is still on our radar, but not on the committed roadmap at this time. We are hoping to get to this soon, and I'll keep this request updated with anything new as we move forward.
M
Mark Green
This is such a painful shortcoming! All I need is the ability to auto-create a group for each team (i.e. "Core UX" and "Reporting" teams are part of the "Core" group, etc). Now I have to do this via automations which is going to be more taxing on the system and hard to keep perfectly in sync. Please support text types for the "FIELD()" operator!
Caroline Ginty
marked this post as
considering
Update Nov 2025: This feature is still on our radar, but not on the committed roadmap at this time. We are hoping to get to this soon, and I'll keep this request updated with anything new as we move forward.
Maxime Teissier
Hey ClickUp
Any visibility on when this could be released?
Any workaround in the mean time?
My use case is that I would like to set up a priority score crossing Tshirt-sized impact, complexity and urgency as in the formula below:
=ROUND(
LET(
I, SWITCH(Impact,""XS"",1,""S"",3,""M"",5,""L"",7,""XL"",9),
C, SWITCH(Complexity,""XS"",6,""S"",5,""M"",4,""L"",3,""XL"",2),
U, SWITCH(Urgency,""XS"",0.5,""S"",0.8,""M"",1,""L"",1.2,""XL"",1.8),
S, I
C
U,(S-1)/(97.2-1)*100
),
0
)
W
Wedo Export
When is this Feature going to be rolled out ...
J
Joseph Plaizier
This is a much needed feature! Please consider prioritizing this!
PaWa
It's a real shame that this feature isn't available yet.
G
Greg Akselrod
When is this planned for?
Caroline Ginty
Merged in a post:
Text, dropdown, etc. to use in formula
Rusty Malapira Palacay
I would be nice if we could use a formula with text, or dropdown with text as a variable like in Microsoft Excel and also have a user-friendly formula bar or where you write your formula, that would be great. Thank you
Caroline Ginty
Rusty Malapira Palacay Thanks for your feedback! I'm going to merge this into the existing Feature Request for using text and dropdown fields in Formulas, but I'd also love to know more about what you're looking for with a "user-friendly formula bar". I know there are challenges with the current formulas editor, which we are actively looking to improve, so it would be great to have more specifics on what pain points you have and what you'd like to see improved there. Thanks!
Rusty Malapira Palacay
Caroline Ginty Hi, it is hard to explain it here. But I can describe the thing that I want is like how you create a formula in spreadsheet, edit/revise formula in spreadsheet, etc. If that user-friendlyness thingy can be combined with the current feature of the formula editor in ClickUp, that would be amazing. Also, if we can have a way to maximize or increase the size of the formula editor as an option? Thank you
Caroline Ginty
Rusty Malapira Palacay Thanks for the details, super helpful!
Caroline Ginty
Merged in a post:
Use string fields in formula field
Antonio Eduardo
Formula fields have many string operation methods, but is not possible to get value from string fields using field("field name").
Load More
→