Checkbox formula for current month and the three next months

Options

Hey everyone I am hoping you can assist me. I am trying to create a formula that will check a box for the current month and the next three months. The formula we have tried is: =IF(AND(MONTH(Month@row) = MONTH(TODAY())+3, YEAR(Month@row) = YEAR(TODAY())), 1, 0)

I have placed a snip below. I know we are in June, so July, August and September would be checked. When we are in July, July - September would be checked. Any help you can provide would be appreciated.



Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!