Format number output from Formula Fields
Caroline Ginty
Consolidating FRs for formatting number outputs from Formula Fields. See this FR for formatting date/time outputs from Formula fields: https://clickup.canny.io/feature-requests/p/format-datetime-output-from-formula-field
Log In
Caroline Ginty
Merged in a post:
Formula function: percentage
Alex Howard
[From support ticket]
In a list I got 2 custom fields, both money type, one for Paid amount and another one calles Amount to pay .
I am looking for a way to have a formula field that brings the % of money paid using both fields mentioned before.
Caroline Ginty
Merged in a post:
Format Formula custom fields (€ / % / etc.)
Julien da Costa
It would be useful if we could format 'Formula' custom fields.
At the moment, if the formula is calculating based on currency (€) custom fields, it displays the result in a currency (€) format.
However, there are cases where we have two currency (€) custom fields and we want the formula field to calculate the percentage difference between them; in those instances, we need the formula field to be in a percentage (%) format.
D
David Shalev
Come on Clickup - you can do this. Clearly lots of your users reference money fields in custom fields and want the outcome to be formatted as a percentage. Please make this happen so we can format custom fields in Clickup as easily as in any spreadsheet on the market. Thank you!
Paco
How is percent formatting for Formula fields still not implemented?
Right now, if a formula references Money fields, the result gets displayed as currency even when the calculation is clearly a percentage (e.g., margin, conversion rate). In my workspace, I can’t even use string functions to append “%”, so there’s no clean workaround.
Is percent formatting for Formula outputs on the roadmap? If so, what’s the current status or timeline? And what’s the recommended best practice in the meantime to avoid confusing “€15.6” when the value is actually 15.6%?
Niklas Buschner
+1 feels to small to not being fixed
Wiezman Kimchi
These requests went back to 2020. Is there any way to make this happens (and fix the answer that is given by the AI: to use the formula TO_CURRENCY())?
Caroline Ginty
Merged in a post:
Be able to format formula field as percentages/add commas/adjust number of digits
Brayden Ankerstein
P
Porfirio Lima
Why is this not possible? Any 2 cent spreadsheet software can do this easily... When will Clickup solve this Caroline Ginty?
Ryan MacAlmon (HPE)
This is much needed
Mostafa Shabanpour
Any type of formula that has an advanced output and ultimately results in a number is not considered as a numerical value, and as a result, simple mathematical operations like sum or average cannot be performed on it. On the other hand, also these formula's output cannot be used in any of the dashboard components. This is a major limitation in reporting, and I hope it gets resolved!!
Photo Viewer
View photos in a modal
M
Mahak Wadhwani
Mostafa Shabanpour Is there any update from ClickUp on this? I still seem to be struggling with this
Load More
→