ContributionsMost RecentMost LikesSolutionsRe: Formula for Status based on fields having blank dataThat worked. Thanks. Formula for Status based on fields having blank dataI 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,