Internal Calculation for Projects from an existing Excel list

Platform discussions
,
1

Hi All,

I am a Project Manager and wanted to calculate the Products prices for internal use( to Calculate Margin) in Monday.com using an existing Excel File from SAP. The Excel File consists of Prices of Products, Production Cost, SAP Material Number and the Type of the Products. How should I upload the File in the Projects Dashboard of Monday.com and calculate the Cost for each project. Any Ideas will be helpful. Thanks in Advance. Cheers!

2

2 options i can think of:

  1. Upload the excel to a new board and connect them.
  2. Build an integration directly to SAP using make

If you need further assistance you can contact me

3

Hello Sharma,
If you’re open to the apps from monday marketplace, Smart Spreadsheet can help in your case.
You can add spreadsheet as a board view, auto-import your board into the spreadsheet and upload your internal spreadsheet. Now you can use monday board values in calculations in your local spreadsheet. Here’s an example:

image
image1694×1031 174 KB