Precentage of Cell 2 out of Cell 1

A Rose
A Rose ✭✭✭✭✭
in Formulas and Functions

Hi,

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

Thank you!

· Share on FacebookShare on Twitter

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)

    percent-button


    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!

    · Share on FacebookShare on Twitter

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)

    percent-button


    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!

    · Share on FacebookShare on Twitter
  • 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!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!