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
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives