Today we are featuring our current favorite new app – Google Sheets. Okay, we are a bit obsessed with Google Sheets over at BBB Headquarters. There is a lot of excited banter about all the new things we have discovered to use.
This month we have been discussing collaboration within the cloud and within your business. If you are not using Google Sheets, you really should consider using it to collaborate.
Ways We Use Google Sheets to Collaborate
Once you create a “sheet” you can share it with folks both inside and outside your organization. You just need to invite them by entering their email address and then they can have access to the sheet too. Anyone can edit and change the information. You can also share a “sheet” by copying and pasting a link within the body of an email. If you want to limit the ability of what others can do in a document, you can edit the Share Screen to “View or “Comment” .
One feature we really like is how you can assign people tasks within it. Once you assign a task to someone using Comments, the assigned user receives a direct notification in their email with a link to the worksheet. Once the person has completed the task they can mark it as completed or leave a comment – both of these will also update the person who originally assigned the task.
What We Love About Google Sheets
Since we all work remotely at BBB, its important for us all to be on the same page even if we are not in the same place. This can be a challenge when all are working remotely.
Google Sheets allows our team all to be on the same page (quite literally). when we are discussing client work. We have developed a template workbook that keeps all our information in order and has assignments for team members to do as well as colors to show if something has been completed. By utilizing this template we can all feel like we have a “pulse” on what is going on for any particular client. Google Sheets has very robust conditional formatting tools. We use these to color code when certain assignments are in progress, ready for review, or completed. This is helpful when we add new clients to the workbook as we don’t spend extra time trying to reformat the workbook.
There are many different aspects of the business that we utilize Google Sheets, as we just mentioned we use it to stay organized with all the companies we work on. Another way is by staying organized within our business.
What I Love About Google Sheets
I personally head up most of the social media/blogging activities of the business. I like to collaborate with team members before posting things, so I have set up some social media templates where I have a schedule and links to blog posts that other social media activities that the team can view and edit or add to. We all work together, but not usually in physically in the same location. Google Sheets allows us to collaborate on projects as well as share our workload in an organized way.
Google Sheets is a great app to use, whether it be for collaboration or just staying organized yourself. We highly recommend you give it a try!