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