Getting Message Column Formula Syntax Isn't Right

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"))

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!