Prioritization and Forced Rank
Hi all!
I'm creating an intake form to help business leaders prioritize and force rank of dependencies.
Example:
Main project: Develop a recyclable lid for water bottles
Owner: Barney Rubble
I'd like to send an update request to Barney asking him to tell me what departments he is depending on to get his project done. For example, he's probably waiting on Finance for an ROI analysis of various types of materials for the lid.
I can include multi-select checkboxes for the department indicators, but how do I then allow Barney to rank which department needs to go first (Finance needs to go first, then R&D, then something else, etc).
How could I get the ranking (dates and prioritization) from an intake form? Any help is appreciated!
Maria
Comments
-
Hi Maria,
You might consider creating additional dropdown fields with a 1-x rank, where 1 is who should go first, 2 is dependent on 1, 3 on 2, etc for each department.
You can request this info in the initial intake form or you can add the columns to your sheet directly, then create an update request that asks them for this ranking info once they've submitted via the intake form.
The latter is more involved but may lead to a cleaner intake form.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives