Health Formula

This is my current formula. I have added a drop down option in my status column "NA". I have also changed my health column to include a gray light option. Can someone help me add this to my current formula. IF (Status@row = "NA", "Gray".

=IFERROR(IF(Status@row = "Complete", "Green", IF(AND(Status@row = "Not Started", [Task Start Date]5 <= TODAY(5)), "Red", IF(AND(Status@row = "In Progress", [Task Start Date]5 <= TODAY(10)), "Yellow")))), "")

Find more posts tagged with

Formulas

Accepted answers

Philip Robbins

=IFERROR(IF(Status@row = "NA", "Gray",IF(Status@row = "Complete", "Green", IF(AND(Status@row = "Not Started", [Task Start Date]5 <= TODAY(5)), "Red", IF(AND(Status@row = "In Progress", [Task Start Date]5 <= TODAY(10)), "Yellow"))))), "")

This should do the job. Let me know if not.

Philip Robbins

@Kelsey L DeOrdio you certainly can. You would need to set up an automation with the following logic:

When rows are changed and when 'Date Started Column' changes to 'Any value', change a cell value ('Status' changes to 'In Progress').

All comments

Philip Robbins

This should do the job. Let me know if not.

Kelsey L DeOrdio

@Philip Robbins This helped!

One more question..

I set up my status column to default to "Not Started"

I have a column where I enter the date I started a task.

Can I set the status column up to change to "In Progress" when a date is entered there?

Philip Robbins

@Kelsey L DeOrdio you certainly can. You would need to set up an automation with the following logic:

When rows are changed and when 'Date Started Column' changes to 'Any value', change a cell value ('Status' changes to 'In Progress').

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.