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.
Caroline Ginty
Merged in a post:
More formula variable compatibility
M
Mike Angelou Balaoro
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.
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
Load More
→