Skip to main content
Question

Formula for Status based on fields having blank data

Forum|alt.badge.img+1
I am trying to use the IF to create a status based on the formula I have created so far:

IF(Trim([Return Tracking])=""&Trim([Shipped Serial])="","1-Request Received",

IFTrim([Return Tracking])<>""&Trim([Received Date])=""&Trim([Shipped Serial])="","2-Tracking Label Sent", 

IFTrim([Serial Received])<>""&Trim([Shipped Serial])="","3-Device Received by Vendor",

IFTrim([Shipped Serial])<>"","4-Closed - Replacement Sent by Vendor"))

So this is based on fields having or not having data in those fields.

All the fields are Text except the date field.

Thanks in advance,

    This topic has been closed for replies.

    Try this

    If it does not work first try, please post your formula and a copy and paste of the error.

    IF(
    Trim([Return Tracking])=""  and Trim([Shipped Serial])="", "1-Request Received", 

    Trim([Return Tracking])<>"" and IsNull([Received Date]) and Trim([Shipped Serial])="", "2-Tracking Label Sent",  

    Trim([Serial Received])<>""  and Trim([Shipped Serial])="", "3-Device Received by Vendor",

    Trim([Shipped Serial])<>"", "4-Closed - Replacement Sent by Vendor")




    Forum|alt.badge.img+1
    • MattMattson
    • Author
    • Registered
    • October 5, 2018
    That worked.  Thanks.
    Terms & ConditionsAccessibility statement