Using IF, AND, OR

@SPark

Looking for formula advice/help! I would like to write a formula that will:

• Mark Past Due if Complete By is greater than today + task is not complete
• If no Complete By date exists, than Past Due flag remains unchecked

So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a Complete By date associated show as flagged. Would I use an OR in this situation? Not even sure if this is possible-- Any thoughts?

@SPark

I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..

=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Genevieve P.

Hi @SPark

So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.

Cheers,

Genevieve

@SPark

I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..

=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Genevieve P.

Hi @SPark

So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.

Cheers,

Genevieve