hello All,
I have a shared spreadsheet where it saves after the users edit certain columns (the first and last of the spreadsheet)
the idea is that when they enter the first it will save and of course if there is a conflict it means they do not have the latest version while the last column is to ensure they save their work.
My issue is I want to ensure when there is conflicting information that it always accepts the other user or the only option is to only accept the other users edit as it shows they are not working with the latest version.
Any help will be greatly appreciated.
I have a shared spreadsheet where it saves after the users edit certain columns (the first and last of the spreadsheet)
the idea is that when they enter the first it will save and of course if there is a conflict it means they do not have the latest version while the last column is to ensure they save their work.
My issue is I want to ensure when there is conflicting information that it always accepts the other user or the only option is to only accept the other users edit as it shows they are not working with the latest version.
Any help will be greatly appreciated.