Smartsheet not recognizing my Date Check formula

I'm trying to use a date check formula from a cell that is linked to another sheet to check the date that is populated by the linked cell to determine data that is presented in another cell.

Here is the formula:

=IF([Date Received]@row < DATE(2023 / 7 / 1), [Total Grandfathered Rent]@row , [Total Standard Rent]@row )

Let me know what is going on and why the sheet keeps saying #INCORRECT AUGMENT SET.

Find more posts tagged with

Accepted answers

Paul Newcome

The DATE function uses commas between the year, month, and day.

DATE(yyyy, mm, dd)

All comments

Paul Newcome

The DATE function uses commas between the year, month, and day.

DATE(yyyy, mm, dd)

Yellow_Cruzer

Great that worked, 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.