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

Izelle Muller

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)

Christian G.

I would use a "Count(collect())" Combo to see if it is bigger then 1.

=if(count(collect({form range 1},{form range 1},=date@row))>=1,1,0)

this will count all the cells that share the same date has the "Availability". If it is greater or equal to 1, the box is ticked.

Paul Newcome

Try this:

=IF(COUNTIFS({Form Sheet Date Column}, @cell = Date@row)> 0, 1)