If Statement Help

Liza0315

I could really use some help! I am trying to write an if statement.

Based on:

Due date being < = -68

New entry is "starred"

Entry 1 = "yes".

I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions.

This is what I tried:

=IF([New Entry]@row = 1, [Entry 1]@row, HAS(@cell, "Yes" ), [Due date]@row <= -68, "Complete", "Incomplete")

Paul Newcome

Apologies. I saw "Due Date" and assumed it was a date type column which is why the number threw me off.

Give this a try:

=IF(AND([New Entry]@row = 1, [Entry 1]@row = "Yes", [Due date]@row <= -68), "Complete", "Incomplete")

Paul Newcome

What exactly do you mean by "Due Date being less than or equal to -68"?

Liza0315

I have this as the formula for the due date:

-68 is the due date number that makes it not required for additional entries due to the time frame.

It is set up so if entry 1 date is entered then there is a designated time frame using the due date to determine if entry 2 is passed due and so on until entry 4 is complete.

Paul Newcome

Apologies. I saw "Due Date" and assumed it was a date type column which is why the number threw me off.

Give this a try:

=IF(AND([New Entry]@row = 1, [Entry 1]@row = "Yes", [Due date]@row <= -68), "Complete", "Incomplete")

Liza0315

That worked thank you!!

I have another question. Is there a way to include this additional criteria with due dates range of -308 and -68?

so keep the original criteria of:

Due date being < = -68

New entry is "starred"

Entry 1 = "yes".

BUT also have this criteria included:

Due date between this range -308 to -68

and entry 2 is "Yes"

and new entry is "starred"

Liza0315

Never mind I figured out a way!

Thank you so much for all of your help!

Paul Newcome

Happy to help.