bgdn.me

A personal blog.

#Smartsheet Articles


  • Mon 15 March 2021
  • Blog

Pull Smartsheet data into Google Sheets

This is a follow-up on this post. Since the time I published it, I've made a couple of improvements that I wanted to share here. First, I've started using Smartsheet reports as the data source instead of sheets. It's because there might be occasional changes to the underlying sheet (like …

  • Thu 06 August 2020
  • Blog

Synchronize Google Sheets with Smartsheet

Smartsheet is a powerful, spreadsheet-like tool. It helps to automate processes in your team. In my current company, we've been using it for years to support project management. Plans, issue logs, risk registers, project dashboards, task trackers - just to name a few examples of what we use Smartsheet for. However …

  • Wed 08 April 2020
  • Blog

The Median in Smartsheet

If you needed the median function in Smartsheet, but couldn't find it, don't get upset. That function, indeed, is not present among supported functions; however, there is the percentile function available in Smartsheet. And the good news is that the median is just another name for the 50th percentile. To …

  • Mon 28 October 2019
  • Blog

Project Manager's Dashboard

When you manage several projects simultaneously, you have to switch context quite a lot. It's important to have a tool that helps update awareness of the current situation on a particular project. You need a dashboard. Information dashboard, when well designed, is a good means to update situational awareness at …