Hi all - I'm having a very strange issue with a Formula field. I've got a Status field (single select) that informs a Formula field. i.e. if the Status field says ABC, then make the Formula field say XYZ. It's working perfectly except for two outputs. Now here's where it gets weird: after extensive testing, the issue seems to be with the output string, not the input.
- If the Status is Booking Received, the Formula field should return "Booking received, waiting for pickup confirmation" but it returns a blank field. I also can't get it to return any results when I change the formula to return my name, the word Test, or gibberish lettering.
- But when I type one of the other results that is working for another status, it works! Meaning if I type "Decline" in to the formula in place of "Booking received, waiting for pickup" it returns Declined. So weird, right?? Why will it only return certain other existing outputs?
- The same thing is happening for the "On hold" result. It will not return the words "On hold" or any random string I test it with, but it will return one of the other existing statuses.
IF(
OR(
{Latest CSF Status} = "Submitted - container cleared",
{Latest CSF Status} = "Closed - lost possession of container"
),
"Shipment & CSF complete",
IF(
OR(
Status = "(SH) Post-load sent",
Status = "(SHI) Invoice pulled",
Status = "(SHIPPED) Docs sent"
),
"Container loaded - waiting for CSF",
IF(
Status = "Tentative",
"Waiting for booking & pickup confirmation",
IF(
Status = "Booking received",
"Booking received, waiting for pickup confirmation",
IF(
Status = "Pickup confirmed",
"Booking received & pickup confirmed",
IF(
OR(
Status = "Declined",
Status = "Released",
Status = "Cancelled"
),
"Declined",
IF(
Status = "Hold",
"On Hold",
""
)
)
)
)
)
)
)
Thanks for any help!
Kelsey
