Formula help - Getting Unparseable!

Lori Leighton
Lori Leighton ✭✭✭✭
edited 04/21/23 in Formulas and Functions

In my formula, I am taking data from three columns 1)if my Room Type field = King and it falls in between the 2) hotel check-in and 3) hotel check-out date to give me a 1. I need to know how many Queen Rooms I need on any given day.

Here is my formula:

=([# of King Rooms Needed]@row = "King") * IF(F(AND(DATE(2023, 7, 29) >= [Hotel Arrival Date]@row, DATE(2023, 7, 29) < [Hotel Departure Date]@row), 1, 0))

I have also tried this:

=COUNTIF({[Room Type]2 = "king"}, (AND(DATE(2023, 7, 29) >= [Hotel Arrival Date]@row, DATE(2023, 7, 29) < [Hotel Departure Date]@row), 1, 0))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!