Forum Discussion

MattMattson's avatar
MattMattson
Qrew Member
7 years ago

Formula for Status based on fields having blank data

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,

App builders
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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")