How to automate a project tracker
System
Employee
This discussion was created from comments split from: Welcome to the online Smartsheet Community!.
Answers
-
I am looking for a way to automatically change a drop-down option based on the data entered into a different cell.
Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine if the project is on track, tracking ahead or tracking behind.
Is there a way to automate the project tracker (on target, tracking ahead, tracking behind) based on the most recent actual goal entry?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives