RYG Balls help

Elizabeth Jones

Hi All,

I would like the RYG balls to represent how closely we are tracking to our timeline.

The bit I need help with is having the Yellow ball appear if the est. finish is within 10 days of the Planned Finish.

=IF([Est. Finish]@row > [Planned Finish]@row, "Red", IF([Est. Finish]@row < [Planned Finish]@row, "Green"))

So if it's within 10 days of the finish date I'd like it to appear yellow. If it's more than that, Red.

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this...

=IF([Start Date]@row > TODAY(), "Grey", IF(INT([Est. Finish]@row - [Planned Finish]@row) < 10, "Yellow", IF([Est. Finish]@row > [Planned Finish]@row, "Red", IF([Est. Finish]@row < [Planned Finish]@row, "Green"))))

All comments

Elizabeth Jones

oops and one more. If the start date is greater than today "Grey"

Paul Newcome

Try something like this...

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.