I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the date is in the past and (3)if another referenced value [Shipping Status] does not have value "Shipped" in it then it flags(value=1), if not on all the above then it will not flag(value=0). Here is what I have so far:
=IF(ISBLANK([Anticipated Ship Date]1), 0, IF([Anticipated Ship Date]1 <= TODAY(), 1, 0))
I cannot wrap my brain around the additional syntax needed to grab variable three. Can someone help me out?