Problems with formulas

SharonR

i am having difficulties with my formulas .

I am trying to acheive the following:

IF status row is not "complete" AND due date is Today or in the past, if true Flag, if not unflag.

My formula is:

=IF(AND(Status28 <> "Completed", [Planned Finish]28 >= TODAY(-15)), 1)

However this is the results - it is not calulation what i want it to show. What am i doing wrong or what have i missed?

Mike Wilday

Duh. I totally missed it! I just noticed that you are looking for "Completed" You should be looking for the word "Complete".

=IF(AND(Status28 <> "Complete", [Planned Finish]28 <= TODAY()), 1)

Mike Wilday

Your current formula is looking at everything that is greater than 15 days ago. So everything in the future is being looked at. To convert that to everything that is less or equal to today, make this change...

=IF(AND(Status28 <> "Completed", [Planned Finish]28 <= TODAY()), 1)

SharonR

I only want it to work on the row that are not Complete, but it is still flagging all completed rows. The time frame i can work with, its that status that is not being recognised in this formula.

This is what has happened with the new formula.

Mike Wilday

Duh. I totally missed it! I just noticed that you are looking for "Completed" You should be looking for the word "Complete".

=IF(AND(Status28 <> "Complete", [Planned Finish]28 <= TODAY()), 1)

Paul Newcome

I do that ALL... THE... TIME...

"Complete" vs "Completed" is definitely in my top 5 most annoying things to work with in formulas.

SharonR

lol Thank you i missed it too and this is more most frequent issue too.

Thanks everyone :)