Update Columns in Existing Row Using Forms
I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each row is auto-numbered for tracking.
Is there a method for a form or process to create forms that uses the Item # (which was auto-numbered when the line item was created) to provide updated information?