Using regular expressions to simplify a submittal log​
I had a co-worker this week complain that Procore, a project management software, wasn’t working as he wished for his management of submittals. This resulted in him exporting Procore’s submittal log from their web application to an excel sheet as he felt that if the data was in excel he would be able to manipulate it more easily.
Writing an Apps Script to cross reference tables in Sheets​
I have spearheaded incorporating Google Forms and QR codes to manage our equipment at my day job. As such, we now have a collection of Google Sheets housing data from the initialization of equipment into our tracking system and various updates about it thereafter.