Need Help with a Formula

Mrawes

I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow

I've tried a few things but can't figure it out. Can anyone help?

NicoLHC

@Mrawes great to see you are working with Smartsheet please try.

=AND([Due Date]@row >= TODAY() + 60, [Due Date]@row <= TODAY() + 90)

NicoLHC

@Mrawes great to see you are working with Smartsheet please try.

=AND([Due Date]@row >= TODAY() + 60, [Due Date]@row <= TODAY() + 90)

Mrawes

Yes I was able to get it working. Thank you for the help.