Overall Project Status
I'm trying to create an overall project status similar to the one displayed in the "Maximize Your Smartsheet Experience" webinar. https://www.smartsheet.com/videos/maximize-your-smartsheet-experience?frame=0&nav=1
Around timestamp 4:50, a task status is updated from red to green via an update request.
Once the status update is submitted and the sheet refreshed, the overall sheet status has automatically changed from Red to Green. This is the automation I am looking to add to my project sheets.
Reason for the automation is similar to the reason in the video. I've created a dashboard for my supervisor to access and quickly view the overall health of my projects.
If anyone has ideas or additional information on this type of automation, please let me know.