Dividing to Create a %
I would like to use the data in Column A and B to create a percentage complete by row NOT by parent/hierarchy. In Excel this would be =sum(Column B/Column A) = %. What is the formula for Smartsheet?
Best Answer
-
You would just use
=[Column B]@row / [Column A]@row
EDIT: Then apply the percentage format to the column.
Answers
-
You would just use
=[Column B]@row / [Column A]@row
EDIT: Then apply the percentage format to the column.
-
I'm not exactly sure this will work because I am not sure what data you have in your Columns.
In the screenshot below Column A is a number from 0-10 and Column B is set to 10. % Complete the value in Column A divided by Column B.
The formula is:
=[Column A]@row / [Column B]@row
If you have a different use case let me know and I can try to help. Screenshots always help!
_____________________________________________________________________________________________
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).
🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response attention use @Dan Palenchar so I get notified of your reply!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Paul and Dan: Your formula worked perfectly! Thank you so much for the quick reply!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!