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

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)

Find more posts tagged with

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.