Help with multiple condition IF formula
Hi, I am trying to create a formula field for a multiple leveled IF question so I can automatically set the status of an instrument in regards to when it should be returned. The bellow Table is a b...
Forum Discussion
to check if most fields are blank, you can use IsNull ( ). But for text fields you need to use a check to see if its equal to "", ie quotes with nothing in them.
I think this will give you an idea of the Syntax.
IF(
Isnull([Install date]) and Trim([Serial number)="", "Requested",
IsNull([Install Date]) and Trim([Serial Number]) <>"", "Assigned",
[Install Date] > Today() and [Contract End Date] > Today() + Days(14), "Installed",
[Contract End Date] < today() + days(14) and Isnull([Returned Date]), "Expiring",
[Contract End Date] >Today() and [Contract date]< today() + days(14) and IsNull([Returned Date]), "Book Collection",
not IsNull([Returned Date]), "Returned",
Trim([PO])<>"", "Sold",
[Contract End Date] > Today()-Days(14) and isNull(Returned Date]) and Trim([PO])="", "Over due")
I think this will give you an idea of the Syntax.
IF(
Isnull([Install date]) and Trim([Serial number)="", "Requested",
IsNull([Install Date]) and Trim([Serial Number]) <>"", "Assigned",
[Install Date] > Today() and [Contract End Date] > Today() + Days(14), "Installed",
[Contract End Date] < today() + days(14) and Isnull([Returned Date]), "Expiring",
[Contract End Date] >Today() and [Contract date]< today() + days(14) and IsNull([Returned Date]), "Book Collection",
not IsNull([Returned Date]), "Returned",
Trim([PO])<>"", "Sold",
[Contract End Date] > Today()-Days(14) and isNull(Returned Date]) and Trim([PO])="", "Over due")