Nested if for FLAG column

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!