Formula help
How can I make a text-formula field with conditions to return Text if another (Date) field is blank? Here is what I tried and have error: (IsNull [ETA Destination Port],"In-Transit"), IsNull [ATA...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNp, just change the = to <>
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Alycn Bjergo-Justen
------------------------------
- MarkShnier__YouThe last line needs two quotes and not just one. Follow the patterns of the previous lines above.
I can't edit your formula if its a screenshot.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - Thank you, this is very difficult. Here is the new error:
------------------------------
Alycn Bjergo-Justen
------------------------------ - MarkShnier__YouSorry, I was multi tasking and did not realize that these are all date fields. Also the sequence matters, so you will need to check for the last sequence first.
IF(
not IsNull([Empty Return Date]),"Empty Returned",,
not IsNull([Port Pickup Date]),"Picked-Up",
not IsNull([ATA Destination Port]),"At Port",
not IsNull ([ETA Destination Port]),"In-Transit", "Not Shipped")
)
IF(
IsNull ([ETA Destination Port]),"In-Transit"),
IsNull ([ATA Destination Port]),"At Port"),
IsNull ([Port Pickup Date]),"Picked-Up"),
IsNull ([Empty Return Date]),"Empty Returned")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - Thanks SO much, I think we finally got it to work!
------------------------------
Alycn Bjergo-Justen
------------------------------
