Multiple Values in a row

BIP
BIP ✭✭
edited 06/20/23 in Add Ons and Integrations

Hi, I'm creating a sheet which is automated and prompts the users that are in the contact list row to fill in the form at a particular date. I'm able to do that with no issues. However, some of the column have multiple values and all the columns are related to each other in some way. For instance one of the columns is titled courses and it has many values . The column next to it is course coordinator. When multiple courses are chosen and the course coordinators are chosen for those courses, I'm not able to determine which course coordinator is responsible for what course, as there are multiple courses and course coordinator in the row. Is there a way we can specify which coordinator is responsible for how many courses in this particular case?


Answers