Making a journal on Google Sheet

Philippines
January 25, 2018 9:00pm CST
I've been using Google Sheet for at least 3 years now and I using it as my regular tool in replacement with Excel. I like it more since it has the auto-saving feature, plus, it is almost impossible to get lost (corrupted). Before, I use it in a very simple way, but right now I am learning some tricks, like making a dropdown, vlookup, and a lot more... my work is getting much easier and faster too. I have met a friend on the Google product forum too who help me with some scripting, like finding a duplicate throughout sheets in google spreadsheets, like invoices automatically... Are you using it too?
1 response
@raijem (335)
• Philippines
26 Jan 18
We have done that during a freelance project for Amazon for purposes of easily sharing a shared spreadsheet online, other than using dropbox. Now you mentioned issues with files getting corrupted or not being saved and losing data too when using offline spreadsheets. For this one, I would suggest you minimize the auto save time to say 3 to 5 minutes instead of the usual 10 minutes that microsoft has for default. It also helps to save files (ctrl+s) regularly to ensure your work is saved and have regular back-ups.