Branching Logic (Trees) on sheet
Hello! I am relatively green when it comes to Smartsheet. I am looking to create a sheet that will track various channels of customer feedback, the solutions, who it is assigned to, WIP, RCA, and status. Currently, we keep these in separate databases and we want to combine them all in Smartsheet. Because the base issues can be a very large "bucket" we want to be able to drill down and have sub-buckets, descriptions, and other specifics tracked in separate columns. Is there a way to have selections in one column based on selections made in another column? Dependencies if you will but it may branch 4-5 columns.
Answers
-
@sam.bird Using Smartsheet forms or drop downs in a sheet, this cannot be done. However, if you use Appsheet you can do this, both to add new rows as well as edit existing rows.
Here is an example using dynamic drop downs where the list of available cities changes based on the state selected. I linked to the relevant part of the video to save you some time.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.8K Get Help
- 335 Global Discussions
- 193 Industry Talk
- 425 Announcements
- 4.3K Ideas & Feature Requests
- 130 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 447 Show & Tell
- 27 Member Spotlight
- 1 SmartStories
- 280 Events
- 34 Webinars
- 7.3K Forum Archives