Eric,
I've updated my attachments. Lots of changes since I started this adventure. Using Google Drive I was able to create a Google Spreadsheet featuring two headers; one for meter number and another for replacement date. The attachment entitled "Google Sheets-Add a Row" corresponds to my configuration of that scenario. I've tested this scenario and it functions very well. An alert is provided via email and the Google Sheet is populated with the corresponding meter number and replacement date from the survey. That's great!
Can you provide some guidance on the next stage? Following your suggestion, I have created a second scenario illustrated in my attachment as "Google Sheets-Search Rows". The final attachment to this posting entitled "Google Sheets-Search Rows Configure" illustrates a screen capture where I am a little stumped. I have a column in Google Sheets entitled Battery Replace Date (MM/DD/YYYY) and Meter Number. Ideally I would like someone to receive the reminder corresponding to the date and supply them with which meter requires its battery to be replaced.
Thank you in advance for any assistance you can provide.
Jeff