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???
Comments
-
Hello—
I'm not exactly sure what you're wanting with the less 365 days part, are you just wanting to see if your test date is within the current month and current year?
If that's the case, you might try placing a formula like the following in a checkbox column:
=IF(AND(MONTH([Start Date]13) = MONTH(TODAY()), YEAR([Start Date]13) = YEAR(TODAY())), 1)
Make sure to change the cell references to match the columns/rows in your own sheet. You're welcome to check out our functions list here: https://help.smartsheet.com/functions
Let me know if that's not what you're wanting and maybe I can come up with another formula.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives