Getting ready to begin using Smartsheet forms and read a bunch of articles online about best practices.
Two questions:
- Is there any way to pull data from another aheet based on user input? For example, if user enters a course code (PPA 123, Smartsheet references another sheet to automatically display the course title.
- Is there a way to force the format of input (e.g. a code entered must be 6 characters and second character must be a letter).