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
Tasha Raynard
Use Case:
We use a Formula custom field in order calculate a month before the due date of a task which can be anywhere from 3 to 12 months away.
We need to be able to utilize the formula date field to either populate another custom field, and/or send a message or perform another action once that custom formulated date arrives.
Currently the "Date custom field arrives" trigger does not allow you to select a formula field, even if it's, a date.
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.
Christian Rigg
Luci N. Have to agree with others that it's extremely disappointing to see this not being prioritized. At 1.4k, it has more upvotes than most of the improvements already committed to production. ClickUp also styles itself as a "replacement" for Notion and Airtable, and yet you can't even concatenate two fields together? Such a frustrating and totally preventable shortcoming. ClickUp consistently falls behind on basic power-user features that make Monday.com, Notion, and Airtable very, very attractive alternatives.
E
Erra Faye Zabat
Hey, Christian! Appreciate you sharing this and for being so candid. I want to reassure you that this is very much on the team’s radar.
If there are any updates, our Product Manager will post them here. In the meantime, please keep sharing your thoughts and use cases. That kind of input genuinely helps guide the team on what to prioritize next.
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.
Load More
→