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
------------------------------
Alycn Bjergo-Justen
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIF(
Trim([ETA Destination Port]) ="", "In-Transit",
Trim([ATA Destination Port]) ="", "At Port",
Trim([Port Pickup Date]) = "", "Picked-Up",
Trim([Empty Return Date]) = ", "Empty Returned")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Trim([ETA Destination Port]) ="", "In-Transit",
Trim([ATA Destination Port]) ="", "At Port",
Trim([Port Pickup Date]) = "", "Picked-Up",
Trim([Empty Return Date]) = ", "Empty Returned")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Alycn Bjergo-Justen
------------------------------- MarkShnier__YouIF(
Trim([ETA Destination Port]) ="", "In-Transit",
Trim([ATA Destination Port]) ="", "At Port",
Trim([Port Pickup Date]) = "", "Picked-Up",
Trim([Empty Return Date]) = "", "Empty Returned")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thanks, how would I make one of those return text if they were NOT blank?
------------------------------
Alycn Bjergo-Justen
------------------------------