Formula for Status based on fields having blank data | Discussions

Expand all | Collapse all

Formula for Status based on fields having blank data

  • 1.  Formula for Status based on fields having blank data

    Posted 10-03-2018 18:06
    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,



  • 2.  RE: Formula for Status based on fields having blank data

    Posted 10-03-2018 20:21
    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")






  • 3.  RE: Formula for Status based on fields having blank data

    Posted 10-05-2018 19:48
    That worked.  Thanks.