Dividing to Create a %

tmkj20

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?

Paul Newcome

You would just use

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

EDIT: Then apply the percentage format to the column.

Paul Newcome

You would just use

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

EDIT: Then apply the percentage format to the column.

SoS | Dan Palenchar

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!

tmkj20

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

Paul Newcome

Happy to help. 👍️