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.
Can you link drop boxes in a web form?
Comments
-
Lynn,
If you aren't talking a lot of people, then nested IF's are what you are looking for
=IF([Select Name]1 = "Bob", "Alice", IF([Select Name]1 = "John", "Sasha", "unassigned"))
This example will look at the [Select Name] column.
If it finds "Bob", then it will show "Alice" as the support person.
If it finds "John", then "Sasha" gets the nod.
Otherwise, there is not a dedicated support person yet, so it will be "unassigned"
However, Contact List type columns can not have formulas, so this won't show up on Resource Views, if you use them.
Hope this helps.
Craig
-
Sorry, just noticed the title of the thread.
If you want to the support person to be shown in the WebForm, that is not currently possible. The formula won't update while the data is being entered and doesn't really "exist" until the form is submitted.
By then, it is too late for the person entering the data to get that sort of feedback.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives