Actual vs Planned in a Task Sheet?
![Amy Marable](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi Smartsheet Community!
I have a task sheet that needs to track the planned and actual dates for 4 different date columns. I am unable to find a way to add planned and actual columns, has anyone successfully done this? If so, then I'd appreciate your feedback.
Thanks!
Amy
Best Answer
-
Hello @Amy Marable
I agree with @Alpha Chucky that you can add Date columns for "Actual" and "Planned" and update these as you need in your Sheet. You can create multiple sets of these as you need them - you mentioned having 4 date columns, so you could use these 4 columns your "Planned" Dates and then add 4 more for "Actuals". Or you could 8 columns to get 4 sets of "Planned" and "Actuals" based on the existing 4.
Smartsheet does have a built in Baselines feature that may help you, though if you have a need for multiple sets of these it might not be sufficient.
See: https://help.smartsheet.com/articles/2482093-baselines
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).
🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
Hi Amy! I am going to assume you are adding your calendar items in rows (one below the other). If so, than, I recommend a column with a drop down called Actual vs Planned. you may need more than one if you have dates in multiple columns.
Projects Delivered. Data Defended.
-
Thanks Alpha Chucky. I am trying to maintain the planned date against the actual dates in columns and across rows in a sheet, not a project plan.
-
Hello @Amy Marable
I agree with @Alpha Chucky that you can add Date columns for "Actual" and "Planned" and update these as you need in your Sheet. You can create multiple sets of these as you need them - you mentioned having 4 date columns, so you could use these 4 columns your "Planned" Dates and then add 4 more for "Actuals". Or you could 8 columns to get 4 sets of "Planned" and "Actuals" based on the existing 4.
Smartsheet does have a built in Baselines feature that may help you, though if you have a need for multiple sets of these it might not be sufficient.
See: https://help.smartsheet.com/articles/2482093-baselines
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).
🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thanks Dan. I am not sure if this will work for this sheet, but will explore the recommendations. Thanks again!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62K Get Help
- 347 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 131 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives