Need a check mark for rows added last month
I want a checkmark to appear when entries were created the previous month. i.e., all April entries would have a checkmark, and starting June 1, only May entries, and so on. I thought the following formula was a good place to begin, but apparently the -1 is only subtracting a day, not a month. =IF(MONTH([Entry Date]@row) = MONTH(TODAY(-1)), 1)
Please advise. Thank you!
Answers
-
That won't work ;-) The function TODAY(-1) will give you yesterday's date, so it has to be MONTH(TODAY())-1for last month
Try the below, (I have factored in the year too as considering only month will give you incorrect results when you have entries from past or next year)
=IFERROR(IF(MONTH(TODAY()) <> 1, IF(AND( (MONTH(TODAY()) - MONTH([Entry Date]@row) = 1), (YEAR(TODAY()) = YEAR([Entry Date]@row)) ), 1, 0), IF(AND( (YEAR(TODAY()) - YEAR([Entry Date]@row) = 1), (MONTH([Entry Date]@row) = 12) ), 1, 0)), 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!