Setting a condition for task within 30 days from todays date.


I am trying to create a condition where any task that is within 30 days from todays date will be highlighted a certain color. When I create the condition

Column "Task" is in the next (days) "30", I do not see the selected columns highlighted when I set the date to 4 days from today or 30 days from today.

Am I missing something?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!