Smartsheet not recognizing my Date Check formula

Yellow_Cruzer

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.

Paul Newcome

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

DATE(yyyy, mm, dd)

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. 👍️