Use any field in formulas, e.g. dropdowns and text (not just number and date fields) | Voters

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?

December 2, 2021

Salomé Wysocki

ClickUp, please prioritize this. I'm simply trying to summarize the total number of checkboxes per task that were marked true (marking attendance), and yet checkboxes are not supported in the formula field. On other platforms like Notion I have never had such a limitation.

Scott Russell

+1
I would especially like to be able to use text-based dropdown fields in formulas.
For example, "IF( field( "Room Type" ) = "Computer Lab", true, false )"
In my case, I have a list of all of our rooms that have AV equipment in them. Our Dean's Office pays a percentage of the room costs and the department pays the rest. Different room type (and other conditions, also in text-based dropdowns) determine the exact amounts.
Thank you!

Phoebe Emma

For what I thought a simple formula would be to create for "Vendor Confirmation %" as the sum of checkboxes divided by 10 vendors, multiplied by 100 but this formula does not seem to work due to the limitations of using checkboxes within the formula area.

Very disappointed.

Natalie Williams

This needs to be prioritized. Formulas are incredibly limited compared to other platforms like Notion and Airtable.
You can't check whether a date field is set, so instead you have to create extra fields and automations as workarounds. 
And the help chatbot continually recommends formulas that use dropdown, checkbox, and text fields, and functions that aren't supported...that's not exactly helpful.

netto.eth

Very much needed!!

Sarah Wills

Would love if formula fields could work with templates. I often create templates and then transfer them to other accounts for my clients to use, but the formula field does not carry across, even without data - column just fully disappears.

Faduma Idiris

This is much needed. Please prioritize this feature

Amanda Fye

Agree! This would really open up the possibilities and hope they prioritize this feature.

Jess Amaris Delgado

I agree with most of the comments here and am surprised this capability hasn’t been implemented yet.

David Koos

I agree with most comments here that in the year 2026 I am not able to reference other than Date and Number fields is hard to believe. But what strikes me most is that you offer string functions like lower, left , etc. What is the point if I cannot reference Text columns, to list those functions. I also did not find any mention in the documentation that only date and number columns are possible.

→