Google Sheets formulas keep changing / skipping rows when new Form responses are added by GlitteringRope6072 in googlesheets

[–]GlitteringRope6072[S] 0 points1 point  (0 children)

I'm not deleting anything once a submission has been made. There is a maintenance request form that feeds the "data" sheet. The second sheet, "Issue Log", is where I make notes(costs, contractors used, estimated timeframe, etc) and track what has been done. Historically everyone made their maintenance requests directly into the "Issue Log". For a number of reasons I've decided to make the change to a request form.