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
-
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
-
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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!