Trouble with exxpressions for initial value

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โ€.

0 2 115
2 REPLIES 2

What is the expression in the [Full Name] column?

Got it fixed. Thanks for asking though.

Top Labels in this Space