IF function, dates, and late/on time

Hi! I'm trying to figure out how to write a formula that will show whether a task was completed on time or after its due date. Here's what I tried, but it didn't work:

=IF([Completion Date]17<=[Due Date]17, Yes, [No])

I'm trying to say if the completion date is on or before the due date, populate the cell with Yes (on time). If the completion date is after the due date, populate the cell with No (late).

Any ideas on how I can fix this? I keep getting the error #UNPARSABLE.

Thank you for any help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!