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.
Hours tracking conundrum
I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one client, oftentimes there are a few consultants working on one client. The consultants need to track their hours on a daily basis, and attribute the hours to a specific client and task. The SS consultant suggested that I set up a sheet for each client, and then set up a report for each consultant. The consultant could then fill in their hours on their report, whick would then update the associated client sheet.
The glitch comes in when more than one consultant has hours for the same client and task as another consultant-- when they put in their hours for a task it would overwrite anything already in the cell. Does anyone have a suggestion for how to track hours by multiple people for the same tasks/projects while keeping a separate sheet for each project? At the end of each month, we need to be able to see how many hours are attributed to each of our 70 clients.
Thanks for any advice and please let me know if you need further clarification/information.