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 010 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!
👨🏼💻 Dan Palenchar  School of Sheets Solutions Consulting  Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡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 tag me @SoS  Dan Palenchar so I get notified of your reply!

Paul and Dan: Your formula worked perfectly! Thank you so much for the quick reply!

Help Article Resources
Categories
Check out the Formula Handbook template!