Decimal Point formula help


Hi All,

Please can you help me with this simple formula

the formula in 'Net Revenue'

=[Sell (LOCAL CURRENCY)]@row - [Cost (LOCAL CURRENCY)]@row

'Rev %'

=[Net Revenue (LOCAL CURRENCY)]@row / [Cost (LOCAL CURRENCY)]@row

but it does not like the decimal places which we need for accurate numbers

Thanks for help in advance


  • Ramzi K
    Ramzi K ✭✭✭✭✭

    It appears that it sees your cell values as text and not numbers. Try highlighting your Cost and Cell columns and converting to number format using this menu bar command:

    I hope this helps.


    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (

    Feel free to email me:

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • david hennessy

    Hi Ramzi,

    Tried this.. the column is set to text/numbers, also added the command and no change

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    Hi @david hennessy

    From your screenshot, it's clear Cost and Sell are strings for Smartsheet, on the second line. Are those numbers directly typed in or do they come from a formula, which may be the first problem.

    Still, you can correct both of your formulas using the VALUE function:

    in 'Net Revenue'

    =VALUE([Sell (LOCAL CURRENCY)]@row) - VALUE([Cost (LOCAL CURRENCY)]@row)

    'Rev %'

    =VALUE([Net Revenue (LOCAL CURRENCY)]@row) / VALUE([Cost (LOCAL CURRENCY)]@row)

    Hope it helped!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!