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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives