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
Check out the Formula Handbook template!