Use any field in formulas, e.g. dropdowns and text (not just number and date fields)
planned
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
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
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").
Jussimir Saul Pasold
I'd love to be able to reference the List and Folder where a task is located in custom field formulas. Currently this isn't possible, but it would be incredibly useful for our workflow. We use each Folder as a client name and each List as a project for that client, so being able to auto-populate custom fields based on task location would save us tons of manual work.
Ché Stevenson
Just want to add my voice to the call for this feature. I need to be able to use dropdown field values as conditions to calculate the earliest possible start date for a project.
Charlie Demsky
A
Andrew Schultz
It's confusing to the user when this DOESN'T work - it makes no sense to an end user that you can only use numeric or date fields in a formula.
Francesca Angemi
Rollup fields too please🙏
Jonas Veltman
Tools like notion habe this kind of feature, that you can build a string, out of all other possible custom fields.
Mario Rader
Is there a timeline on this feature yet?
This would be great – my use case is, that I use "My Dropdown" with options like …
1 – none
2 – some
3 – many
… and I would like to use the first character in a formula to calculate a score; seems as if all the gears are already in place – LEFT(field("My Dropdown"), 1) * 1) – but it won't let me use field("My Dropdown") in the formula, unless all the option values are numeric.
Load More
→