Pivot Board formatting option choose how many decimals to show

When pivoting data from connected boards, the numbers column always shows decimals. It would be great to be able to select the number format and choose how many decimals to show. For example, I do not want my pivot full of numbers like 5.00 or 10.00 - all i need it the integers 5 or 10.

Cheers team

Hi,

You can create a formula that reads the number column and rounds it using the following formula: ROUND({number column}, no. of the decimal)

Hope this helps!

Cheers,
Harsh


We empower businesses to unlock Monday’s full potential, driving growth and operational excellence.
Learn more about us on Fario Consulting