CHANGE CELL IF CRITERIA ARE MET

eventsagp

Hello,

I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 to show if the date and time is chosen the status in Cabin 1 - Status is not "BOOKED" not Available.

How can I do that?

Eric Law

https://community.smartsheet.com/discussion/114266/change-cell-if-criteria-are-met

Hello, I would recommend adding a date column in Sheet 2, as it will make updating your sheet easier, call it date, instead of having that date on the top row, which is weird. Also, please post your formula in plain text so we can easily type out a working formula based off your references. Anyhow, adding in a date column will allow you to use the following

=IF(COUNTIFS(the date range, Date@row, the timing range, Time@row)>0, "BOOKED", "AVAILABLE)

eventsagp

So I added now the date and time.

=IF(COUNTIFS(the date range, Date@row, the timing range, Time@row)>0, "BOOKED", "AVAILABLE) but it is uparsable

Cabin 1 - Schedule Slot is dropdown list instead of dates, because of the logic I had to use.

But I added the formula and it shows unparsable.

Eric Law

https://community.smartsheet.com/discussion/comment/409511#Comment_409511

So you need to add in the date range and the timing range... I didn't do that for you because it's your sheet that you are linking.

Also, now that you've updated your other sheet to have multiple columns, that formula will no longer work since you've changed the parameters.