Formula help for previous month
I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!
Answers
-
-
@Paul Newcome Thanks for the tip. It worked, however, now after the year change it doesn't work for December when we're in January. Any idea how I can fix this?
-
@paddy Try this:
=IF(MONTH([Date Column]@row) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), 1)
-
@Paul Newcome Awesome! Thank you so much.
-
@paddy Happy to help. 👍️
-
@Paul Newcome You're the best!
-
Hi @Paul Newcome, would you mind explaining how this formula works?
Thank you,
-
If the MONTH of the date in [Date Column]@row is equal to 12 or the Month of TODAY minus 1 depending on the MONTH of TODAY, then output 1.
-
Thank you @Paul Newcome
-
To take into account the year, see this thread: https://community.smartsheet.com/discussion/comment/412060#Comment_412060
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
