How to format specific/named date in If/Then formula

I have a column for the record Create Date. I have a column within the grid that needs to evaluate the CREATE DATE compared to a specific date - 10/27/2023.

I've tried several variations of formatting the date within the IF statement with no success:

=IF(Created@row < 10 / 27 / 23, "blank", "not blank") .... Smartsheet forces the spaces into the format here.

=IF(Created@row < "10/27/23, "blank", "not blank") = Invalid Op

=IF(Created@row < [10/27/23], "blank", "not blank") = Invalid Op

=IF(Created@row < '10/27/23', "blank", "not blank") = unparseable

Surely I don't have to create a helper column just to hold this marker-date to do the calculation, right?

Find more posts tagged with

Accepted answers

Paul Newcome

You would put the DATE function inside of the IF function.

=IF(Created@row< DATE(2023, 10, 27), .....

All comments

markj1

You will need to use a Date Function to tell it the Created@row is a date, without it the formula doesn't know what to compare to. For example, if you change the Create Date column properties to Text/Number your first formula should work. This isn't the full answer but might help.

=IF(Created@row > 10 / 27 / 23, "blank", "not blank")

Brian Becnel

I found the valid DATE function that works ... =DATE(2023, 10, 27) in a "helper" column...just need to get it to work in the IF statement without the helper column.

Thanks for the pointer!

Paul Newcome

You would put the DATE function inside of the IF function.

=IF(Created@row< DATE(2023, 10, 27), .....

Brian Becnel

@Paul Newcome That helped AND i was able to successfully include it and a vlookup in one formula (eliminating 2 additional columns.....

=IF(Created@row < DATE(2023, 10, 27), [Review Month v1]@row, VLOOKUP(Created@row, {Master Fiscal Review Month}, 18, false))

Thank you.

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.