Tasks due within # of days

Sorry I know this is silly but can't figure out the formula looking at examples. I want a value returned if 'target end date' is due with 7, 15, 30. I have this working but can't seem to figure out how to add the additional criteria to include the other values. The values I want to return are just looking at Target End Date --

=IF(TODAY() >= [Target End Date]@row, "LATE ", "") --

How do I add the extra conditions?

Find more posts tagged with

Formulas

Accepted answers

L_123

=if([Target End Date]@row < today(),"Late",if([Target End Date]@row < today()+7, "Due in Next Week", if([Target End Date]@row < today() + 15, "Due in Next 15 Days", [Target End Date]@row < today()+ 30, "Due in Next 30 Days"

Or something similar. You can post a completion check as well at the beginning of the statement to say what you want if the status is complete

All comments

L_123

Or something similar. You can post a completion check as well at the beginning of the statement to say what you want if the status is complete

Sborror

Thank you so much! This worked!

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.