formula for status column using symbols based on end and target dates

Hello,

I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like:

If end date is not past target date then status is green

If end date is past target date then status is red

Could someone help with the formula?

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

Jen Castillo

Do you want it based on the current date, or is there a "task due today" column?

If there is a task due today column:

=IF([target date]@row > [task due today]@row, "Green", "Red")

If it is based on the current day:

=IF(TODAY() < [target date]@row, "Green", "Red")

All comments

Jen Castillo

Do you want it based on the current date, or is there a "task due today" column?

If there is a task due today column:

=IF([target date]@row > [task due today]@row, "Green", "Red")

If it is based on the current day:

=IF(TODAY() < [target date]@row, "Green", "Red")

QueryQuill

This worked! Thank you!

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.