=Rounddown( not rounding down

Hi All.

I have two cells Text/Number each and looking for the average of, but regardless of how I construct the formulas I end up with 35.700%, What I want is 35.7%. Results cell is formatted to % and to the lowest allowable decimal. Have I missed something?

=AVG([Total Activations Yr24]@row, [Completed design tasks]140)

=ROUNDDOWN(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100

=ROUND(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100

Thanks for any help.

Cheers.

Answers

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi @Jason P,

    I just tested this out on my sheet and I think I got it to work the way that you want it.

    Incorrect:

    =AVG(Value@row, [Value 2]@row) / 100
    

    Now using ROUNDDOWN with 1 decimal place:

    =ROUNDDOWN(AVG(Value@row, [Value 2]@row) / 100, 1)
    

    This was bad it made everything after the decimal "00". So I went back to the first formula and adjusted my column's decimal position:

    =AVG(Value@row, [Value 2]@row) / 100
    

    I think this 3rd screenshot is what you want? Is this correct?

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports

  • Jason P
    Jason P ✭✭✭✭✭

    Hi @SSFeatures

    Sorted - thank you

    Cheers.

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    You're welcome!

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!