Skip to main content

Lookup + Single Select Formula

  • December 16, 2020
  • 1 reply
  • 14 views

I would like to do a lookup based on what is selected in a Single Select field.

For example:
IF single select field is A, Lookup Record X
IF single select field is B, Lookup Record Y

How can this be set up to avoid errors?

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • December 16, 2020

Lookups are based on Linked Record fields. So you would need to choose either Record X or Record Y in your linked record field.