Decimal Point formula help

Options

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

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    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

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

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

  • david hennessy
    Options

    Hi Ramzi,


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

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Options

    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!