So Google sheets is Google's equivalent to Excel. Is anyone familiar with it? It has a Time Stamp function where someone within Google Groups set me up with the code to do this. And it worked well for a time.
However, for whatever reason the script started to return an error in the timestamp. The theory is that with 6 to 7 agents using this function at once (on separate tabs of the same sheet) that it 'overloaded' the function, causing the page to report an error in the timestamp column. Is a google sheet limited in any kind of way by the amount of users? Or can this be chalked up to synching issues which I know have caused the timestamp to spit out the same exact time for 20-30 cells at a time? I've also considered that there is probably a data or cell limit so we started archiving each prior month into an excel sheet being that with 6 agents and 6 columns to feel with on average 80 or over orders processed per agent we're looking at 3000 cells used a
day. No more than 8 people should be accessing the same sheet at once and currently the code generates a stamp when an agent types the last digit of the Order ID in the Order ID column. Could it be 2 or 3 agents generating a stamp only a second apart (which would have to be a pretty rare occurrence) causing this issue?
I've included an image. Any help with this would be massively appreciated- even if its directing me to a forum that could better answer it. What would be the best source- Google Groups- has turned out to be a failure.