If then greater than or equal to....

I am working on a task list that will return green, yellow, or red based on criteria with today's date and the due date. Everything appears to be working unless the total equals the today - the due date + 7. I have this column formula and one cell will not work correctly. Help!

=IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() - [Due Date]@row >= Duration@row + 7, "Red")))

I ended up changing the formula to =IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() > [Due Date]@row, "Red"))).

Find more posts tagged with

Accepted answers

All comments

ShelbyWarren

@blmccue When I put the formula in a test sheet it works for me. Did the formula end up working for you?

blmccue

Shelby, the original formula would not work so I changed it to:

=IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() > [Due Date]@row, "Red"))).

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.