Formula to Change Status Symbols

Aimee Eckert

I am looking for a formula that will change the symbols "Status" column.

If "Target End Date" is in the past AND "Task Progress" is In Progress - Yellow

If "Target End Date" is in the past AND "Task Progress" is Not Started - Red

If "Target End Date" is not in the past leave it - Green

Edge.png

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Aimee Eckert

=IF([Task Progress]@row="Completed", "Green", IF([Target End Date]@row>=TODAY(), "Green", IF(AND([Target End Date]@row<TODAY(), [Task Progress]@row="Not Started"), "Red", "Yellow")))

Does this work for you?

Kelly

All comments

Kelly Moore

Hey @Aimee Eckert

=IF([Task Progress]@row="Completed", "Green", IF([Target End Date]@row>=TODAY(), "Green", IF(AND([Target End Date]@row<TODAY(), [Task Progress]@row="Not Started"), "Red", "Yellow")))

Does this work for you?

Kelly

Aimee Eckert

Yes Kelly! Thank you so much!

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.