Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional Drop-down list

edited 12/09/19 in Archived 2017 Posts

Good afternoon,

Currently, my company is using smartsheet to build up a database of our quality issues. Since the department is new to this, data entered is not very robust: Many auditors simply log in, type in their name, work station and enter text describing issues as they encounter them.

I want to take this to the next level and create a structural data gathering process, and conditions need to be defined so that issues can be well categorized.

For example, we make this flow (for a phone manufacturer), each step will reveal its own sub-category:

1. Where does the issue occur?

  • Workstation 1
  • Workstation 2
  • Warehouse
  • Shipping

User selected Work Station 2

2. What is the nature of the the issue

  • Wrong component built
  • Missing component
  • Missing lables

User selected Wrong component built

3. Which component was incorrect?

  • Screen
  • Body
  • Memory

User selected one and then add additional details if needed.

As you can see, this nested, procedural form would help classify issues in a meaningful way; in this manner, we can find out where the issues occur, the nature of them or let's say what components tend to cause the most issues.

I don't think this can be done in smartsheet - but can it be done using a third party and then integrated into an existing sheet? We like this platform because we can use it for different department and the forms are helpful to share accessibility across the company - but this level of complexity may need some further development.




This discussion has been closed.