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

Cristina Ayala
Cristina Ayala ✭✭✭✭
in Formulas and Functions

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?

· Share on FacebookShare on Twitter

Best Answer

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!