If then else on Is Null
I have the following formula in a Formula Text field. I know who to make this work in Visual Basic but having trouble in Quickbase. Can someone assist in the correct layout? If (not IsNull([Pend ...
Forum Discussion
Sorry, I was missing commas
If(not IsNull([Pend on Date Assigned to]) and IsNull([Pend off Date Assigned to]), "Pending",
not IsNull([Pend on Date Transferred to]) and IsNull([Pend off Date Transferred to]), "Pending",
not IsNull([Pend On Date ReOpened By]) and IsNull([Pend Off Date ReOpened by]), "Pending",
"Open")
If(not IsNull([Pend on Date Assigned to]) and IsNull([Pend off Date Assigned to]), "Pending",
not IsNull([Pend on Date Transferred to]) and IsNull([Pend off Date Transferred to]), "Pending",
not IsNull([Pend On Date ReOpened By]) and IsNull([Pend Off Date ReOpened by]), "Pending",
"Open")