New row autofill
I want to autofill new rows with formulas that would execute as data is loaded into certain fields. Specifically, someone uses a form to start a new row. In the form there is a logic option but not a real conditional with a formula.
It may not be available in the Form but what about the Sheet? There is languaging about two rows before or after that is unclear.
My goal is to eliminate as much administrative info - Site Name, location, etc. as possible to allow the Field Officer to focus on the details of a Spill. The administrative data already exists in a separate sheet.
Help Article Resources
Check out the Formula Handbook template!