Precentage of Cell 2 out of Cell 1

Hi,

What formula caculates the precentage of [Column A] row 1, out of [Column B] Row 1

Thank you!

Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓

    Hello there,

    =[Column A]@row/[Column B]@row

    That ought to do it. To get it to display as a percentage, you'll need to head to the top menu bar and select that.

    (use the Percentage Format button in the toolbar)


    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Answers

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓

    Hello there,

    =[Column A]@row/[Column B]@row

    That ought to do it. To get it to display as a percentage, you'll need to head to the top menu bar and select that.

    (use the Percentage Format button in the toolbar)


    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • A Rose
    A Rose ✭✭✭

    How would I do a 2 or 3 digit number in the result (I.e., 99% or 100% not 2.78125), and it should also have a "%" at the end?

    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!