0-30, 31-60, 61-90 Columns automated by formula (Checkbox)

I have a 3 column breakdown of 0-30, 31-60, 61-90 days and a want a formula to check the box between these based off the current dates listed for the task.

What I currently have is =IF([End Date]@row < (Today@row + 31), [End Date]@row >= Today@row), 1, 0) but receive an error when doing so. How can i get this to automatically check this box? and then check the box if it falls under one of the other categories?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!