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
Thank you and it is starting to work.
I made some changes to the formula but not quote there on some of the variants and i cant work out why;
I am not seeing any "Installed" as these are showing as "expiring".
"Book collection" is before the expiry date not on or after Company Owned end date passes.It is also showing the "Book Colection period as "Over Due"
Any Ideas? I have pasted the latest version of the formula for you below. The returned and PO is working really well.
If(
IsNull([Install Date]) and Trim([Serial Number])="", "Requested", IsNull([Install Date]) and Trim([Serial Number]) <>"", "Assigned",
[Install Date] > Today() and [Company Owned End] < Today() - Days(14), "Installed",
[Company Owned End] > Today() + Days(14) and IsNull([Return Date]), "Expiring",
[Company Owned End] >Today() and [Company Owned End]< Today() + Days(14) and IsNull([Return Date]), "Book Collection",
not IsNull([Return Date]), "Returned",
Trim([PO])<>"", "Sold",
[Company Owned End] < Today()+ Days(14) and IsNull([Return Date]) and Trim([PO])="", "Over due")
I made some changes to the formula but not quote there on some of the variants and i cant work out why;
I am not seeing any "Installed" as these are showing as "expiring".
"Book collection" is before the expiry date not on or after Company Owned end date passes.It is also showing the "Book Colection period as "Over Due"
Any Ideas? I have pasted the latest version of the formula for you below. The returned and PO is working really well.
If(
IsNull([Install Date]) and Trim([Serial Number])="", "Requested", IsNull([Install Date]) and Trim([Serial Number]) <>"", "Assigned",
[Install Date] > Today() and [Company Owned End] < Today() - Days(14), "Installed",
[Company Owned End] > Today() + Days(14) and IsNull([Return Date]), "Expiring",
[Company Owned End] >Today() and [Company Owned End]< Today() + Days(14) and IsNull([Return Date]), "Book Collection",
not IsNull([Return Date]), "Returned",
Trim([PO])<>"", "Sold",
[Company Owned End] < Today()+ Days(14) and IsNull([Return Date]) and Trim([PO])="", "Over due")