two factor RGB balls formula. Status and Date

J.Barrow

I know this has been asked a million times and I have looked at all the other post, but still cant get it to work.

Status options are:

Not Started

In Progress

Completed

Transferred To Other Department

Due date is standard date format

I am trying this as the formula:

=IF(Status@row = "Transferred To Other Department", "Green", IF(Status@row = "Complete", "Green", IF([Response/ Resolution Deadline]@row - TODAY() < 0, "Red", IF([Response/ Resolution Deadline]@row - TODAY() <= +5, "Yellow", "Green",))))

I know I am just missing something but I cant figure it out.

Jamie

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @J.Barrow

Is the problem an UNPARSEABLE error? There is an extra comma after your last Green. If this is not the problem, please help us understand if it's an error (what error?) or an unexpected result (what result and what was expected).

Kelly

All comments

Kelly Moore

Hey @J.Barrow

Kelly

J.Barrow

Well yes it was part of the problem, but now it still is going red even when things are marked completed or moved to another department when they should be green.

J.Barrow

Oops I found the problem the Completed was complete

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.