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
Dani
This completely nullifies the use of the formula field. If you can't properly format the output they are almost completely useless?
Total $ Needed / Cost Per Unit $
$200,000 / $2,000 = $1621.62
I need to be able to show that it takes 1,621 units to achieve the goal...not $
Caroline Ginty
Merged in a post:
Formula field to display result as percentage
G
Gabriel Lander
The formula field (as well as numbers field) doesn't allow to show percentage, for example.
I need to calculate a rate dividing to $ fields, and the result is a certain percentage, but it only shows something like: $0.7 and there's no way to make it show as 70%.
Caroline Ginty
Merged in a post:
Formatting Options for Formula Fields
Destiny Pidgeon
My formula field is inheriting the formatting from one of the fields in the calculation.
I am trying to take a $ field that is a total value, then divide it by the $ value that would be billed hourly. The calculation should read as a number, not a $ amount.
There is currently no option to change the formatting that is in the formula field.
Mark Winstein
If we could output a Time field as time and use that in Workload View to allocate a persons availability, that would solve problems for every single power user in CU
S
Sam Garden
yes essential, I was surprised I could not easily do this
S
Shannon Sciuto
Yes this would be great.
Caroline Ginty
Caroline Ginty
Merged in a post:
Additional Precision for Money Field
Jared Naito
It would be very helpful to have additional precision in Money fields, especially when used in conjunction with Formula fields. When multiplied out with large quantities, significant error can be realized when $0.0745 is rounded to $0.07.
Caroline Ginty
Load More
→