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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!