Multiple Values in a row

BIP

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?

Screenshot 2023-06-20 164945.png

Andrée Starå

Hi @BIP

I hope you're well and safe!

I'd recommend breaking out the courses on multiple rows (by the coordinator).

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BIP

BIP

https://community.smartsheet.com/discussion/comment/381240#Comment_381240

Hi @Andrée Starå

I'm well, hope you're doing fine too

Thank you for answering my question.

I've set that up in a way where the Program Manager is under the column type 'contact list' and they are the ones filling the form when prompted to.

If I break out the courses on multiple rows, the program manager has to fill out number of forms depending on how many different course coordinators are looking after the courses per program. That is fine if there's only 2/3 course coordinators but in some instances there are several.

I tried doing that and the program manager has to end up answering about 50 forms for different programs.

Is there a better way to set this up? Thank you