Nested if for FLAG column

Daniel Child

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?

Daniel Child

=IF(ISBLANK([Anticipated Ship Date]1), 0, IF([Shipping Status]1 = "Shipped", 0, IF([Anticipated Ship Date]1 < TODAY(), 1, 0)))

Nevermind - I think I got it.

Daniel Child

=IF(ISBLANK([Anticipated Ship Date]1), 0, IF([Shipping Status]1 = "Shipped", 0, IF([Anticipated Ship Date]1 < TODAY(), 1, 0)))

Nevermind - I think I got it.

Andrée Starå

Hi Daniel,

Glad you got it working and thanks for sharing!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!