Hello everyone. Once again, I am faced with another head scratcher of sorts.
My App (haven’t quite given it an appropriate name yet):
So here it is. I am trying to create a Yard Survey for my job in the Post Office. Essentially, I need someone to physically go through the yard and “survey” all trailers on each letter line (as noted in the Reports sheet) and jot down the trailer number, contents, yada yada.
That is the easy part. The problem I’m facing is that if the trailer is no longer in that spot, or the trailer is gone (i.e. taken to another facility or office or whatever) then the all other visible AND editable components would need to be empty.
I tried using an ArrayFormula in the appropriate column in the sheet, but everytime I edit the contents in the app and so forth, it ends up deleting the function altogether.
I would be remissed if I didn’t mention that this survey is conducted at least 3 times a day, 7 days a week.
Any assistance would be most appreciated.