It must be possible to specify the field type in a formula field
João Jesus
On a "formula field", it have to be possible to specify the type of result: text, number, money, date, time or date + time.
If we concatenate 2 text fields, we want the result to be text.
If we multiply a price by the quantity, we want the result to be money.
If we add X days to a date, we want the result to be a date.
Etc.
So, in order for formulas to work correctly in a wide variety of situations, this is very important.
Please see on the attached picture how the software "Filemaker Pro" deals with this kind of field. We need something similar on ClickUp.
Log In
Caroline Ginty
Thanks for this request João Jesus! We hope to add a lot more functionality to Formulas in the second half of this year, and will definitely keep this in mind. Do you have some specific examples of Formulas that currently aren't working well for you in ClickUp? I'd be happy to help you find some solutions; I believe all the examples you shared above can be achieved in Formulas today.
João Jesus
Hello Caroline Ginty.
Some examples are:
1 - Imagine that I have 2 text fields: "Name" and "City" and I want fo have a formula field (usually using the "concatenate" function) that allows to have this result on a formula field "John lives in London".
2 - Imagine that I have a field called "Price" and another field called "Quantity". I want to have a formula field that shows the result of Price x Quantity, where the result is formated as money (€ 30,00).
3 - Imagine that I have a "Due Date" field (which is a Date field type), and I want to add a 2nd field to the same table that shows me the "Due Date + 4 days in the future).
Thanks!
Caroline Ginty
João Jesus Thanks for the additional details! Formatting outputs for Formulas is an existing feature request here:
That being said, I believe that all of the examples you referenced are already supported today in ClickUp's Formulas. Using CONCATENATE is the current workaround to adding a € symbol to your currency calculation, for example: CONCATENATE('€', (YOUR FORMULA)). Cheers!