igors✭

Hi Paul, We decided to allow users to enter multiple dates in a Sheet instead of a Form for two customer service reasons: Users can do it once per week and report multiple daily activities on one line instead of filling the Form seven times. Users can see how many other people are doing it and it will motivate them to do…

Hi Paul, Thank you! It will allow us to calculate the total hours. But we have another problem: I would like to calculate how many hours Per Week each participant accumulated. I need to convert each date into a Week and then total the hours per person. How can I extract individual dates from the Multiple Select column?…