Use any (standard/custom) field in formulas (not just number and date fields)
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
Bruno S. Rosa
Soooo.. Any News?
Oriana Gilbert
My team needs the ability to concatenate a date field with text from another field for quick status updates. Please release limits on the concatenate function!!
Caroline Ginty
Merged in a post:
Survey Result Calculations
C
Crystal Erber
I would like a feature added where we can calculate an overall survey response score based on the custom drop down responses to multiple questions. i.e. I ask 10 questions, 7 responses are strongly agree and 3 responses are disagree-Each response category would be weighted and it would generate a calculation.
Andrew Maslin
We have a Custom Field (Label) called Customer. Whenever a customer raises an issue, we add that Customer to the task. A task can have many customers assigned. We'd like to be able to count how customers are assigned to a task so we can prioritise tasks with multiple Customers (obviously a major issue to resolve).
D
David Koehler
This is very important to me - would like it to be both for options in either dropdowns or checkbox i.e. IF(field("Checkbox")=yes,...
Tony Wilson
Agreed - this is quite necessary for me. I'm an accounting firm owner, and I want to create my own custom automations that allow me to set monthly due dates based on business day, not calendar day. I can easily calculate the business day but I have no way of incorporating what I've calculated into the automation for "change due date."
Anastasia Kolomoytseva
I would like a possibility counting number of comments in Formula. Or number of selected custom fields
Aaron Shuman
We have a list where a prospect's full name is their task name, and I'm very disappointed to find that we can't split their full name into first and last using a formula field or automation (unless I'm mistaken). As others have said, this should definitely be a priority!
S
Stephanie Henry
Hey Caroline Ginty back on March 8, 2023 you merged a bunch of advanced formulas topics into this post.
But on the same day you created a new separate topic asking for advanced formulas: https://clickup.canny.io/feature-requests/p/more-advanced-functions-in-formulas
And here's another advanced formula field post: https://clickup.canny.io/feature-requests/p/use-a-formula-field-in-another-formula-field
I think it would make the most sense to keep them all in this thread, no?
Caroline Ginty
Stephanie Henry: We'll be building these out separately, so it's easiest from a status update perspective to keep them separate! Thanks!
S
Stephanie Henry
Not being able to reference basic text/drop-down fields in formulas = we're living in the stone ages here. This is one area where Notion wins hands down... And it's free 😭😭 Come on Clickup, it's time to get with the program here!
Load More
→