Multiple Values in a row
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
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives