Truncating a field

Vickie Seeber

In Excel we can use TRUNC to take the end off of a field, but I can't find how to make that work in Smartsheet. It might be my formatting. What I am trying to do is remove the cents from a currency ($1.75 should show as $1 instead of rounding up). Is this possible? Thanks in advance.

Mark Cronk

Hi @Vickie Seeber ,

You can format your column as currency and then reduce the decimal places. However, the value you see will be rounded. $1.75 will show as $2.

If you want to always round down you need to use a formula. =ROUNDDOWN(XXXXX@row, 0) where XXXXX is the name of your currency column.

You may need to insert a text/number helper column if the cell you want to round isn't a formula. Add a column [Trunc] to your sheet and insert the column formula =ROUNDDOWN(XXXXX@row, 0) so it rounds the column with your currency value. Use that column anytime you want to view the rounded number.

Help?

Mark

Mark Cronk

Hi @Vickie Seeber ,

You can format your column as currency and then reduce the decimal places. However, the value you see will be rounded. $1.75 will show as $2.

If you want to always round down you need to use a formula. =ROUNDDOWN(XXXXX@row, 0) where XXXXX is the name of your currency column.

You may need to insert a text/number helper column if the cell you want to round isn't a formula. Add a column [Trunc] to your sheet and insert the column formula =ROUNDDOWN(XXXXX@row, 0) so it rounds the column with your currency value. Use that column anytime you want to view the rounded number.

Help?

Mark