Formulas -Automated at risk status

Hi all,

I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist.

Red: % Done is equal to 0% and the Start Date has passed

Yellow: % Done is bigger than 1%

Green: % Done is 100%

the formula I'm coming is this: =IF([% Done]1 > 1%, "Yellow", IF(AND([% Done]1 = 0%, [Start Date]1 < TODAY(), "Red", IF([% Done]1 = 100%, "Green"))

but I cannot make it work...any ideas??

Find more posts tagged with

Formulas

Project Management

Accepted answers

Paul Newcome

Percentages in formulas are referenced as part of a whole or part of one. So 100% = 1, 50% = 0.5, 25% = 0.25, so on and so forth.

Try something like this...

=IF([% Done]@row = 1, "Green", IF([% Done]@row > 0, "Yellow", IF([Start Date]@row < TODAY(), "Red")))

All comments

Paul Newcome

Percentages in formulas are referenced as part of a whole or part of one. So 100% = 1, 50% = 0.5, 25% = 0.25, so on and so forth.

Try something like this...

=IF([% Done]@row = 1, "Green", IF([% Done]@row > 0, "Yellow", IF([Start Date]@row < TODAY(), "Red")))

Zacharias Vailakis

thanks a lot! that resolved all the issues, and works like a charm!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.