Last Modified Values Incorrect
We have a sheet that sends out alerts to a couple hundred people who have no access to our sheet. As people fill out their forms the Last Modified By column changes to list their email. I've noticed that the emails listed there sometimes hop onto other rows, and say someone else had last edited that row when it's not true. It's a big problem because when other alerts go out, they list at the bottom who last edited the row and it's showing other people's names which worries people.
E.g. John Doe fills out his form. Now, the Last Modified By field on his row says [email protected]. But it also jumps onto Jane Doe's row and says [email protected] last edited hers. By the time Jane receives her form, the email says that changes were last made by the sheet owner AND johndoe@gmail.
This happen to anyone else?