I am trying to automate something.
I am having people submit a form. In this form, Column/Question 2 corresponds to a Multiple Select field where they can select their name from a dropdown. Column/Question 3 is where they input a time and then they hit submit
I want the value from Sheet 2 Person A Column 3 to add with the value on Sheet 1 Person A Column 3, value from Sheet 2 Person B Column 3 to add with the value on Sheet 2 Person B Column 3 etc.
I have spent the past 3 days trying to figure it out with rollup and I’m still super confused.
Any help is appreciated.
Thanks in advance!