Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

INDIRECT Substitute

Topic Labels: Formulas
Solved
Jump to Solution
755 1
cancel
Showing results for 
Search instead for 
Did you mean: 
OfficeOurs
7 - App Architect
7 - App Architect

Is there any substitute for INDIRECT in AirTable?

1 Solution

Accepted Solutions
OfficeOurs
7 - App Architect
7 - App Architect

The key is using an intemediate dynamic field. Say I want to refer to {A} if my dropdown says A and to {B} if my dropdown says B.

Switch({dropdown}, "A", {A}, "B", {B})

Then drop in the Dynamic (Switch) field wherever you need a dynamic value. 

 

See Solution in Thread

1 Reply 1
OfficeOurs
7 - App Architect
7 - App Architect

The key is using an intemediate dynamic field. Say I want to refer to {A} if my dropdown says A and to {B} if my dropdown says B.

Switch({dropdown}, "A", {A}, "B", {B})

Then drop in the Dynamic (Switch) field wherever you need a dynamic value.