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])<...
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")