VLOOKUP for form options
Hi, I have 5 Programs of work, each with multiples projects in each (3-24). When a user is completing the associated form and selects a particular Program, I want to use a VLOOKUP on a different grid (or something) to present dropdown options of projects for just that Program in the form. I currently have 5 separate columns in the original grid for each of the project lists which is making my reports messy, so would rather have just one column.
Is this possible? I'm new to Smartsheets and would appreciate any advice :).
Help Article Resources
Check out the Formula Handbook template!