If Index collect formula to capture the Meeting slot availability

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 10/24/23 in Formulas and Functions

Hi All,

I'm attempting to compare data from one sheet, which contains meeting bookings, with another sheet that lists all available meeting slots. My formula seems to work correctly when the condition is met ("True"), but it results in an "#INVALID VALUE" error when the condition is not met ("False").

Can someone assist me in resolving this issue with the formula?

=IF(INDEX(COLLECT({Meeting Intake - Meeting Room}, {Meeting Intake - Meeting Room}, @cell = [Meeting Room]@row, {Meeting Intake Date}, @cell = Date@row, {Meeting Intake Meeting Slot}, @cell = [Meeting Slots]@row), 1) = [Meeting Room]@row, "Booked", "Available")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!