Comparing a Date

This formula is returning INVALID OPERATION. I am going to be doing much more than this as a final formula, but if I can't get this to work, I can't go any further. I'm not too familiar with Date formulas yet. Originally I had 07/01/2021, but it was suggested to be year, month, day?

=IF([Anticipated Project Start Date]@row = <21 / 7 / 1, "Yes")

Can anyone see what I am doing wrong here?

My Anticipated Project Start Date is a Date field and is restricted to Dates.

One interesting fact - I created a test column and called it "Date". Then I put this formula in it: =[Anticipated Project Start Date]@row. Both Columns are Date fields, restricted to Date values. And I get the following Error Message: "This column is restricted to dates." If I made the column called "Date" equal another column that has a date value, why wouldn't this work? Unless you can't put a formula within a date field?

Any help / direction is greatly appreciated.




Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!