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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives