What is the best way to collect resources time using Smartsheet Form?
Using forms, I am trying to collect the time my resources spend each week across multiple project codes. I am looking for total hours spent by project during a time period. I would want to collect the following information
User Name, Start Period, End Period, Project Code, Hours
I can do this when it is one project code, but I am stuck when i want them to enter time for more than 1 project. I would like the second project entry to create a new row so I can see total hours for each project when summarized across resources.