Using If Function to make an update to a Reference Sheet.
Thank you at start!
Field Officers (FO) are inspecting Well Pads for issues. There are 344 pads for them to visit per quarter. They inspect a pad and input the results of their pad inspection into Sheet1 row. Somewhere between initial going on pad and finishing loading data in Pad Inspection Form, I want SS to look for the same well pad "Location" in Sheet1 as in Sheet2. Sheet1 is for loading new inspections data and Sheet2 has the 344 Pad records to be inspected quarterly.
Execution - =if(Sheet1:location1=Sheet2:location@cell, Sheet2:Found@cell=Sheet2:Found+1,)
Question: Is my equation about right? There could be multiple well pads with the same general location (like Section, Township, Range - 21-149-92. Will my equation update all of the pads with the same general location? Will the found be updated everytime an addition is made to Sheet1? Should I be more specific and Concatenate the Pad name -> first 4 letters with the location ID in Sheet1 and Sheet2 and use that as the search variable?
Ultimately – I just want the FOs to complete their Quarterly 344 inspections and I need to track this and push if not all 344 have been inspected. I may want to create a Done column in Sheet 1 so that the Found cell via Location@row is added to the new record. Not critical but interesting statistic.
Once the FO finishes loading information on their pad inspection into the Sheet1@row, the Sheet1@row will be automatically moved (via Automation) to PadInspArchive Sheet.
Help Article Resources
Check out the Formula Handbook template!