Receiving the error โExpressions in schema โLeads_Schemaโ have a circular definition. Check app formulas and initial values for column โFull Nameโโ when using the expression:
SWITCH(
[_THISROW].[Manufacturer],
GM, LOOKUP([_THISROW].[Pin Code], โGMโ, โPin Code*โ, โFull Name*โ),
CDJR, LOOKUP([_THISROW].[Pin Code], โCDJRโ, โPin Code*โ, โFull Name*โ),
Honda, LOOKUP([_THISROW].[Pin Code], โHondaโ, โPin Code*โ, โFull Name*โ),
Ford, LOOKUP([_THISROW].[Pin Code], โFordโ, โPin Code*โ, โFull Name*โ),
KIa, LOOKUP([_THISROW].[Pin Code], โKiaโ, โPin Code*โ, โFull Name*โ),
Nissan, LOOKUP([_THISROW].[Pin Code], โNissanโ, โPin Code*โ, โFull Name*โ),
Hyundai, LOOKUP([_THISROW].[Pin Code], โHyundaiโ, โPin Code*โ, โFull Name*โ),
Toyota, LOOKUP([_THISROW].[Pin Code], โToyotaโ, โPin Code*โ, โFull Name*โ),
LOOKUP([_THISROW].[Pin Code], โManifestโ, โPin Code*โ, โFull Name*โ)
)
The same expression works for other fields like โAddressโ, but not โFull Nameโ.
What is the expression in the [Full Name] column?
Got it fixed. Thanks for asking though.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |