Check if today is in between the date in two cells

I am trying to get a formula to return a specific value if today is in between the date of two cells in a sheet, but I'm getting an #UNPARSEABLE error. This is the formula I am using:

=IF(AND(TODAY() > [Temp Move 1 Move In Date]@row, TODAY() <= [Temp Move 1 Move Out Date]@row), "Temp Move 1", "Not Temp Move 1"))

The column names of the dates I am comparing are Temp Move 1 Move In Date and Temp Move 1 Move Out Date.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!