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

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    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). 

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    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

This discussion has been closed.