Objective

Our team members across different countries update each project's status into a single smartsheet (like google sheet) cell like the image shown below. This project aims to transform team collaboration messages from Smartsheet into a clear and concise timeline.

This is convenient for team collaboration, but as the number of project increases, it became very hard to read and to get the latest status. So my goal is to visualize the text based status column and make it easier to read and understand the current status.

Implementation

I setup a system-d Python program on Linux server that will access and extract the data from smartsheet through API on a daily basis, the program will automatically clean the data and separate the date from the status message using regex, and then store all the cleaned and processed date into a database.

I developed a web page that will convert the data of each project to a horizontal timeline, the web page will update everyday, with newly updated projects on top, and will also differentiate the completed projects. The result is as below. The source code is in my Github.