Complex Formula Help


Every year / half year, we need to figure out the business awarded/quoted ratio amount 18 active suppliers/factories among our 7 core categories. This helps us better understand each supplier/factories competitiveness in each category. Currently, we are manually calculating the % and it's very time consuming. What I would like to do is move this from Excel to Smartsheets, which I have already done. Where I am running into an issue is figuring out a formula for the following two columns:

  1. Hit Rate (LH) - Column J in the Excel Attachment
  2. Supplier Hit Rate - Column K in the Excel Attachment.

If possible, I would like to keep it all in one grid, but I am open to suggestion.

I have attached the Excel document for your reference. Again, any help / suggestions would be greatly appreciated.

Anthony D'Ambrosio

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!