Can a form return the content of an autofilled cell?
I am gathering information using a form that generates and auto number for the new row. I want to pass back the status of a process related to that auto number. I have a column with the status calculated but I can't figure out a way to pass it back to specific row in another sheet. I would normally us and INDEX/MATCH function but the criteria isn't there to do that until the form is filled out. I'm trying to save the requester the process of going to the sheet and looking up the auto number to find out the current status of the request.
Appreciate any help or thoughts anyone has!
Help Article Resources
Check out the Formula Handbook template!