Getting Message Column Formula Syntax Isn't Right

Hammermill21

Hello,

I have the formula below that works, but when I try to "convert to a column formula", I get the error. Does anyone have any ideas why?

Thank you!

=IF([Date & Time]@row = $[Date & Time]$2, "8:30 AM - 9:45 AM", IF([Date & Time]@row = $[Date & Time]$3, "3:30 PM - 4:45 PM"))

Hammermill21

I figured out the issue! I can't have a specific row number in the formula!