Sum data from a sheet and then update to another sheet in google sheets via make.com

i have a google sheet which contains calibration data having columns (Date, Month, Year, T/L #, Capacity, Carriage Name, CNIC/NTN Number, Calibration Date, Calibration Month, Amount Without Sales Tax (Rs.), Sales Tax 16%, Total Amount With Sales Tax, Demand draft no., Bank, Status,), Status column has a validation list as “Same Month, Next Month and Still Pending” in data sheet as below screenshot

i want to calculate data as “Month”, “Year” and (validation list) converting as columns naming “Same Month, Next Month and Still Pending” instead of “Status” in calculations sheet by using make.com. act as an automation expert and provide step-by-step complete process to get data from data sheet to make.com and sum values as mentioned above and then update to calculations sheet in ggogle sheets as below screenshot

1 Like

Hi @Ijaz_Ahmad
You can use the “Search Rows” module in Make to get all the data from your “Data” sheet. After that, use the “Numeric Aggregator” module to group the rows by “Month”, “Year”, and “Status”, and then calculate the total amount for each group. Finally, use the “Update Row” or “Add Row” module to send the summarized results to your “Calculations” sheet. This way, the totals for “Same Month”, “Next Month”, and “Still Pending” will be calculated and updated automatically each month. Let us know if you want further help.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

yes i want help to setting it up…

1 Like