Formula for Status based on fields having blank data

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
  • (Edited)
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,

Photo of Matt Mattson

Matt Mattson

  • 100 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
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")




Photo of Matt Mattson

Matt Mattson

  • 100 Points 100 badge 2x thumb
That worked.  Thanks.