IF, AND Formula for multiple parameters

Hello,

How do I create a formula for this scenario? I want the RYG Ball on the task level to automatically change colors when the dates on:

Finish is less than TODAY= Green

Finish is TODAY= Yellow

Finish is Greater than TODAY= RED

But I also want the RYG ball to turn green if the status has been marked complete, no matter what the finish date is?

Attached are the columns I am using:

Screen Shot 2020-06-24 at 10.40.08 AM.png

Find more posts tagged with

Accepted answers

All comments

I'd recommend a nested if/or statement over an if/and. something along the lines of:

=IF(OR(Status@row="Complete", Finish@row<TODAY()), Turn ball green, IF(Finish@row=Today(), Turn Ball Yellow, Turn Ball Red))

I haven't played with the RYG balls yet so I'm not familiar with the specific requirements to get that accomplished.

Sorry I can't give you a complete answer

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.