IF and Vlookup Statement


I'm not sure if should I do it right

What I would like to achieve:

Smartsheet A - with list of the application name and ID

Smartsheet B - will collect information from Smartsheet A


I use if statement below and give me error # INVALID OPERATION

=IF({import Info Range 1}="PDI", VLOOKUP([Primary Column]@row, {import Info Range 2}, 3, true))


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!