Status bar help


Hello all,

I am pretty new to using Smartsheet but I am loving all of the functionality that has come with it. However I seem to be stuck on the formula for the blue status bar at the top level. For the child items in my example the bar simply fills up as soon as the completed box is checked, which is what I was going. My problem is I cannot figure out how to use the different stages of the status bar as each month is check off from Empty, Quarter, Half, Three Quarter, and Full.

Any help is appreciated




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!