I need of the proper formula to calculate percentage.

C. Phillips

I have two columns, an Open Proposals column and a Proposed closed column. I need a formula that will calculate at what percentage our close ratio is. I would be grateful for any help someone may take out of their day to help. Thank you!

=Chris Palmer

Is this what you're going for?

=[Proposed Closed]@row / [Open Proposals]@row

Make sure the column that contains the formula is a %

=Chris Palmer

https://community.smartsheet.com/discussion/comment/418440#Comment_418440

Glad this worked for you!

=Chris Palmer

Is this what you're going for?

=[Proposed Closed]@row / [Open Proposals]@row

Make sure the column that contains the formula is a %

C. Phillips

Mr. Chris,

This is exactly what I needed. Thank you kindly for your help and support. Have a great day!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/418440#Comment_418440

Glad this worked for you!