How to use IF function to compare two dates and tick checkbox

Options

I would like to use a IF function that test that when the date that the user input in a form in the Form sheet is the same is the date listed in the "Availability" sheet, it must tick the checkbox.

I am currently using this formula but get a "INVALID OPERATION" error. Both columns are 'Date' type.

The objective is to use it as a booking form where a report will show which dates are still available to be booked (the unchecked rows)



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!