Posts

Showing posts from February, 2018

Google Sheets: Recovering past data

Image
I was recently working on invoices and manually transferring over hours-worked and realized I need to put some time into creating a better application that works for me—something I have been planning on and slowly creating for the past 3 year. I know there are many applications out there that help track time and invoice all in one. But I am the type of person that needs flexibility and options. Plus, I love creating all the things . Cut to—me working in Google Sheets and trying to figure out how to customize my current time tracking system. My goal was to create formulas that would simplify my process (but I'll spare you the tedious details for another post). In order to not mess with all of the hours tracked for multiple projects I created copies of my Google Sheets. Welp, I ended up messing up the originals (something that could have been prevented by closing a tab). Thankfully, invoices had been compiled previously to verify that this solution did indeed work. Steps for