#ERROR using SUBSTITUTE()

[OfficeOurs]

Is there any substitute for INDIRECT in AirTable?

[OfficeOurs · Accepted solution]

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.