Help

INDIRECT Substitute

Topic Labels: Formulas
Solved
Jump to Solution
375 1
cancel
Showing results for 
Search instead for 
Did you mean: 
OfficeOurs
6 - Interface Innovator
6 - Interface Innovator

Is there any substitute for INDIRECT in AirTable?

1 Solution

Accepted Solutions
OfficeOurs
6 - Interface Innovator
6 - Interface Innovator

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
6 - Interface Innovator
6 - Interface Innovator

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.