Use any field in formulas, e.g. dropdowns and text (not just number and date fields)
future
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
Luci N.
marked this post as
future
Hey, everyone! We've updated the status of this request to reflect its roadmap status. The Product Manager will provide updates on this post when they have new details to share! For more details about our statuses, check out this post!
Idril Orden
Marking this as "Future" after 4 years of user requests is a concerning signal regarding product priorities.
We are trying to build robust business logic on your platform, but the inability to reference text-based dropdowns in formulas forces us to rely on brittle workarounds (like mapping integers to text) that degrade the user experience and data integrity.
It is difficult to justify why resources are being poured into Generative AI features when the platform's core logic engine still lacks basic string comparison capabilities—a fundamental requirement that competitors like Notion and Airtable solved years ago.
By deprioritizing this for another cycle ("won't be working on it for a while"), you are effectively telling business users that we cannot rely on ClickUp for complex workflows. Please reconsider prioritizing core stability over runaway feature expansion.
Caroline Ginty
Merged in a post:
More formula variable compatibility
B
BALAORO, MIKE ANGELOU ROÑA
All types of fields should be allowed to be a variable in the formula.
Andy Donaldson
Frustrating that this feature is put on the sidelines given that ClickUp is meant to be a project management platform.
Recently, we have started to use a RICE score to prioritise our projects, similar to Canny's features. I was hoping to have this all in ClickUp, with everything being in one place.
As formula fields can't reference a dropdown (allowing me to use an IF function to replace the string with its respective numerical value), I'm now having to either use a separate platform (Google Sheets, Canny etc) or use ~23 automations to set the numerical value whilst having two fields for each individual RICE value.
Inefficient.
Aron Liedtke
Andy Donaldson you could prob just use the AI feature for that, calculations are pretty good now
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.
Natalie Williams
Caroline Ginty in Airtable & Notion if you have two text fields, you can combine them with a formula field.
One use case.
First Name (text CF)
Last Name (text CF)
First + Last Name (formula CF)
This would simplify so many workflows for my teams.
Caroline Ginty
Natalie Williams Thanks! I hear you, and this is something we definitely want to get built out in ClickUp as well as soon as we're able to get it prioritized.
Natalie Williams
Caroline Ginty I sincerely hope that it is prioritized.
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?
Load More
→