Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 27, 2023 03:22 AM
Hi everyone,
I have an issue with the color formatting for Formula Feilds displayed as progress bars, it seems buggy:
With decimal percentages the conditions are not recognized properly, I have the following conditions on a field
but the results are unfortunately wrong for values that are near the "breakpoints".
Any suggestions?
Thanks
Solved! Go to Solution.
Oct 27, 2023 09:56 AM
In my sample the formula for the percent field (named percent) is similar,
Oct 27, 2023 04:11 AM
Hi @loewe,
I've tried it, seem like color condition apparently can only handle integers.
It is a regret.
Oct 27, 2023 08:52 AM
Seems like I'm nitpicking, but it's a rounding limitation rather than an integer limitation (49% is actually .49 not 49). Taking that into consideration, if you can display the percent figure separate from the bar, then adjust the formula for the bar to something like percent-.0049 you should get the desired color. In the sample below 50% is the cutoff for the color changing from red to yellow, so the original on the left is incorrect, the adjustment on the right is correct.
Oct 27, 2023 09:23 AM
Oct 27, 2023 09:56 AM
In my sample the formula for the percent field (named percent) is similar,
Oct 27, 2023 06:50 PM - edited Oct 27, 2023 06:51 PM
I was confused and deleted my earlier post...
I see, so you mean subtract 0.0049
Excellent solution!
Oct 29, 2023 02:16 AM
Thanks @BillH
although I must say that'd be better if the field would work as expected instead of implementing this workaround😅
Thanks gain and have a great day
Oct 30, 2023 06:04 AM
I'm glad it worked. I agree it would be far better if the field worked correctly, but then again, if everything worked as well as expected a lot of us would be unemployed.
Oct 31, 2023 05:47 AM
😂