Calculate Difference Between Latest Entry and Previous Entry (Dates)
We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform.
I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name: Calculate Weekly Usage = current reading - previous reading (readings in the 1 column by reading date)* I am not sure how to make this if statement using dates and meter name criteria... I will note that the readings are not always exactly 7 days apart.
We would also like to eventually create alerts for when usage variance % goes over a threshold. How do I do that?