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.
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
Comments
-
I'm not clear on this.
Β
Are you trying to extract information from many sheets?
Β
You might look into Reports based on Assigned To, date columns, or some other column that will tell you the task is being actively worked on.
Craig -
Thanks for looking into this. I want to create a weekyl sheet that contains the name of each employee, and in that row or column add the job he is or was working on (multiple jobs per day).Β
-
Do you permissions to create sheets (you need to be a licensed user to create and own sheets)
Β
If you can, then on the Home tab, click "Create New" and select Blank Sheet.
That starts with 6 columns.
Β
Rename the first one ([Primary Column]) to something like Name.
Rename the second one Project
Change the third one to a Date type column and change the name to Work Day.
Β
Then start populating.
Β
Craig
