I want to be able to select your name and your assigned support person populates the next block
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.
