Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to easily capture Actual Time spent on a Task in SmartSheet?
Fellow SmartSheet Community Members,
We have recently started using SmartSheet for planning out a roadmap for initiatives, along with types of roles allocated to the initiative (resources) as well as allocation. We are now looking for creative ways to capture "Actual" time spent on a particular initiative. Here are our requirements:
1. Individual resources/team members would capture time, probably on a weekly basis. We need a solution that can scale to 40+ resources conducting this activity.
2. The solution needs to be very easy to use - otherwise it will be hard to get compliance on time capture.
3. The solution needs to be able to automatically aggregate time captured by various team members on an initiative and "roll it up" at the initiative level to give us a nice comparison of planned burn rate vs. actual.
We currently use Harvest as a way to capture time, but there is only a unidirectional sync (per my understanding) from SmartSheet to Harvest, not the other way around. Open to any creative suggestions and ideas from the community on how this could be done or is being done by others.
Appreciate your assistance in helping solve this!