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.
Consolidate time sheets
Hi relative newbie here... looking for help. I would like to set up time sheets for individual team members is a design studio. They will list jobs worked on by job number to allocate time worked on daily. I would then like to consolidate all the data into one master sheet and run a SUM IF formula to calculate the total amount of time spent on each job and allocate the time calculated to each job number. I need help in finding a way to consolidate each time sheet into a master sheet to run the SUM IF formula. Hope this makes sense. Thanks in advance