Fix script on google sheet
Budget: $30 – $50 AUD
It seems there might be an issue with the calculations or the script functioning incorrectly. I need someone to address and resolve this problem. Please refer to the explanation below for an understanding of how the spreadsheet scripts/spreadsheet is supposed to operate.
In our spreadsheet system, we have two distinct buttons that perform separate but complementary actions:
Button 1: "Start"
Functionality: When you click on the "Start" button, it triggers a process that consolidates Product IDs (SKUs) totals from Sheets 1, 2, and 3.
Outcome: The result of this action is the creation of a new Sheet 4 showing the totals of sheets 1,2 and 3 on sheet 4. This sheet displays all the SKUs from Sheets 1, 2, and 3, along with their respective totals. Each SKU is listed with the sum of its occurrences or values across the first three sheets.
- - - - - - - - - - - - - - - - - - -
Button 2: "Calculate Totals"
Functionality: The "Calculate Totals" button is designed to perform a comprehensive summing action.
Outcome: Upon activation, it sums the totals from Sheets 1, 2, 3. The final summed totals are then displayed on Sheet 4 (which are sheets 1,2,3). This means that Sheet 4 will show not only the individual SKU totals from the first three sheets but also the combined total of all these values.
Sheet 3 should display a subtotal at its bottom, reflecting the total quantities and inventory $ values of all SKUs listed on it.
Sheet 4, once generated, is designed to present a consolidated total at its bottom and in each matching cell from sheets 1,2,3. This total combines the figures from Sheets 1, 2, 3, and 4.Its basically a carbon copy of sheet 3 but with all the totals from all sheets.
Sheet 4 is generated with a label that 'warns not to edit' (Attached)
For inventory value calculations on Sheet 3, each product's price is located in the cell immediately following its respective product cell.
If any cell is 0 the cell is auto-highlighted in light red
We require assistance to rectify the current issues with the sheet so that it functions correctly. Please ensure to test your work thoroughly before submission. Initially, work on a separate version and only integrate it into the live version once it is confirmed to be functioning correctly.
In our spreadsheet system, we have two distinct buttons that perform separate but complementary actions:
Button 1: "Start"
Functionality: When you click on the "Start" button, it triggers a process that consolidates Product IDs (SKUs) totals from Sheets 1, 2, and 3.
Outcome: The result of this action is the creation of a new Sheet 4 showing the totals of sheets 1,2 and 3 on sheet 4. This sheet displays all the SKUs from Sheets 1, 2, and 3, along with their respective totals. Each SKU is listed with the sum of its occurrences or values across the first three sheets.
- - - - - - - - - - - - - - - - - - -
Button 2: "Calculate Totals"
Functionality: The "Calculate Totals" button is designed to perform a comprehensive summing action.
Outcome: Upon activation, it sums the totals from Sheets 1, 2, 3. The final summed totals are then displayed on Sheet 4 (which are sheets 1,2,3). This means that Sheet 4 will show not only the individual SKU totals from the first three sheets but also the combined total of all these values.
Sheet 3 should display a subtotal at its bottom, reflecting the total quantities and inventory $ values of all SKUs listed on it.
Sheet 4, once generated, is designed to present a consolidated total at its bottom and in each matching cell from sheets 1,2,3. This total combines the figures from Sheets 1, 2, 3, and 4.Its basically a carbon copy of sheet 3 but with all the totals from all sheets.
Sheet 4 is generated with a label that 'warns not to edit' (Attached)
For inventory value calculations on Sheet 3, each product's price is located in the cell immediately following its respective product cell.
If any cell is 0 the cell is auto-highlighted in light red
We require assistance to rectify the current issues with the sheet so that it functions correctly. Please ensure to test your work thoroughly before submission. Initially, work on a separate version and only integrate it into the live version once it is confirmed to be functioning correctly.