Install Comparison Actual to Projected

Good Morning Community. I wanted to ask a question as it pertains to a comparison. We have been asked to show a chart that displays installed, not installed and projected installed. The premise is that in our project we have specific dates that are targeted for installation but with everything in project management that date may not be accurate and we may not be able to install. Our leadership wants to see a chart that shows what was installed, what was supposed to be installed in that timeline and what is not installed. Does anyone have any ideas. Right now columns that have in our sheet our Installed which is a check mark and projected installed which is also a check mark. I am trying to figure out how to add the projected installed into my dashboard. I appreciate any assistance that can be provided.

Dashboard Representation

Fields currently in project sheet

Tags:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!