Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date.
So basically the test date less 365 days, and then checking if that date is within the current month (for example June 2017) it would be ticked.
I know I could introduce another column which takes the test date less 365 days, then the checkbox checks that column, but i'd rather not introduce yet another column.
Any ideas please???