# Dividing to Create a %

Options
✭✭✭

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?

• ✭✭✭✭✭✭
Options

You would just use

=[Column B]@row / [Column A]@row

EDIT: Then apply the percentage format to the column.

• ✭✭✭✭✭✭
Options

You would just use

=[Column B]@row / [Column A]@row

EDIT: Then apply the percentage format to the column.

• ✭✭✭✭✭✭
Options

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

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 it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!