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:
- Hit Rate (LH) - Column J in the Excel Attachment
- 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.