Date over 30 days = "text" formula help

I have a column where a date will be entered. Based on that date in another column, I want to state "Pending" if the date is over 30 days past the original entry date.

=IF([DeliveryDate]@row > TODAY(+30), "Pending")

I'm not getting errors with this, however, the text "Pending" is not displaying when the DeliveryDate is over the 30 day mark.

Any direction is appreciated.

Find more posts tagged with

Formulas

Accepted answers

Bassam Khalil

Hi @Nathan Horn

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(TODAY(-30) > [Delivery Date]@row, "Pending")

All comments

Bassam Khalil

Hi @Nathan Horn

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(TODAY(-30) > [Delivery Date]@row, "Pending")

Nathan Horn

Bassam,

This works perfectly. Thank you for your assistant!

Bassam Khalil

@Nathan Horn

you are more than welcome

don't forget to vote for me :)

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.