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")

Find more posts tagged with

IF(

Accepted answers

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")

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.