Planned vs Actual Start & End Dates

Hello,
I have data in Smartsheets (pic of SSData) that I need transposed into a chart /graphic. I've attached the view that I need to see or create rather, in the pic called Planned vs Actual_SS (this is something I have created in Excel). Is it possible to replicate this in Smartsheets?
THanks
Answers
-
I think you would want to do something in dashboards - https://help.smartsheet.com/learning-track/level-3-advanced-users/dashboards. You'd create a chart widget from that SSData and you can pick the colors, what the x and y axis are, etc.
-
@Brad Schutts is correct. You will have to use a dashboard to recreate this in Smartsheet. The chart widget is really easy to use and get the results you are looking for.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Hey @Safiya B
Just to clarify here: Chart Widgets in Dashboards require numerical data. It looks like you want the Y axis to be Dates, which is currently not possible in Dashboard Charts as the column won't know when to stop.
What I would suggest doing here is use the Baseline feature in a Project Sheet which would then show the planned/actual dates in the Gantt view. Here's a free webinar with more information: Keep Your Projects on Track with Baselines
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives