Rounding

Majid Kayani

@Genevieve P. I hope you are well sorry to as again, please could i have some assistance on the below question.

 I want to type in 5979.100258 in a cell, for example, and it's rounding up to 5979.10026 - which I don't want. How can I get my numbers to remain exact?

sorry to direct this one to directly.

Genevieve P.

Hi @Majid Kayani

The Smartsheet maximum for decimals is currently 5 decimal places.

Paul has an alternate solution in this post:

https://community.smartsheet.com/discussion/70181/long-decimals-7-digit-decimals

However keep in mind that this will store the values as text values, so you wouldn't be able to do math calculations (such as SUM).

Cheers,

Genevieve