Formula to check a box if the date in another column is the current month
Looking for a formula to check a box if the date in another column is the current month. Needing this to set up a process in which I can filter to Month to Date
Nick Blocker - Analytics Adventurer
Best Answers
-
=IF(MONTH(Created@row) = MONTH(TODAY()), 1, 0)
-
=IF(MONTH(Created@row) = MONTH(TODAY()) - 1, 1, 0)
-
It's only checking the month. You will want to check both month and year.
=IF(AND(MONTH(Created@row) = MONTH(TODAY()), YEAR(Created@row) = YEAR(TODAY())), 1, 0)
=IF(AND(MONTH(Created@row) = MONTH(TODAY())-1, YEAR(Created@row) = YEAR(TODAY())), 1, 0)
-
Looks like you have a second @row in your formula for June. Other than that, you are missing a return if the last IF statement if false.
=IF([Created Month]@row = "1", "JAN", IF([Created Month]@row = "2", "FEB", IF([Created Month]@row = "3", "MAR", IF([Created Month]@row = "4", "APR", IF([Created Month]@row = "5", "MAY", IF([Created Month]@row = "6", "JUN", IF([Created Month]@row = "7", "JUL", IF([Created Month]@row = "8", "AUG", IF([Created Month]@row = "9", "SEP", IF([Created Month]@row = "10", "OCT", IF([Created Month]@row = "11", "NOV", IF([Created Month]@row = "12", "DEC", ""))))))))))))
Answers
-
=IF(MONTH(Created@row) = MONTH(TODAY()), 1, 0)
-
@Devin Lee Thank you for replying so quickly! I truly appreciate your help. How can you modify the formula to check the box if its last month?
Nick Blocker - Analytics Adventurer
-
=IF(MONTH(Created@row) = MONTH(TODAY()) - 1, 1, 0)
-
@Devin Lee thank you for being amazing and quick at replying to my question. If I could by you a coffee I would!😎☕️
Nick Blocker - Analytics Adventurer
-
@Devin Lee Any thoughts on why the formula is including dates in 2023? I did ensure that the date columns are formated as dates.
Nick Blocker - Analytics Adventurer
-
It's only checking the month. You will want to check both month and year.
=IF(AND(MONTH(Created@row) = MONTH(TODAY()), YEAR(Created@row) = YEAR(TODAY())), 1, 0)
=IF(AND(MONTH(Created@row) = MONTH(TODAY())-1, YEAR(Created@row) = YEAR(TODAY())), 1, 0)
-
@Devin Lee I hope you can help me here and let me know where I am going wrong in my formula to extract the month "Name"
=IF([Created Month]@row = "1", "JAN", IF([Created Month]@row = "2", "FEB", IF([Created Month]@row = "3", "MAR", IF([Created Month]@row = "4", "APR", IF([Created Month]@row = "5", "MAY", IF([Created Month]@row @row = "6", "JUN", IF([Created Month]@row = "7", "JUL", IF([Created Month]@row = "8", "AUG", IF([Created Month]@row = "9", "SEP", IF([Created Month]@row = "10", "OCT", IF([Created Month]@row = "11", "NOV", IF([Created Month]@row = "12", "DEC"))))))))))))
Nick Blocker - Analytics Adventurer
-
I use this one in a sheet for dates. Try this:
=IF([Created Month]@row = "12", "DEC", IF([Created Month]@row = "11", "NOV", IF([Created Month]@row = "10", "OCT", IF(OR([Created Month]@row = "9", [Created Month]@row = "09"), "SEP", IF(OR([Created Month]@row = "8", [Created Month]@row = "08"), "AUG", IF(OR([Created Month]@row = "7", [Created Month]@row = "07"), "JUL", IF(OR([Created Month]@row = "6", [Created Month]@row = "06"), "JUN", IF(OR([Created Month]@row = "5", [Created Month]@row = "05"), "MAY", IF(OR([Created Month]@row = "4", [Created Month]@row = "04"), "APR", IF(OR([Created Month]@row = "3", [Created Month]@row = "03"), "MAR", IF(OR([Created Month]@row = "2", [Created Month]@row = "02"), "FEB", IF(OR([Created Month]@row = "1", [Created Month]@row = "01"), "JAN"))))))))))))
Hope this helps.
Peggy
-
Looks like you have a second @row in your formula for June. Other than that, you are missing a return if the last IF statement if false.
=IF([Created Month]@row = "1", "JAN", IF([Created Month]@row = "2", "FEB", IF([Created Month]@row = "3", "MAR", IF([Created Month]@row = "4", "APR", IF([Created Month]@row = "5", "MAY", IF([Created Month]@row = "6", "JUN", IF([Created Month]@row = "7", "JUL", IF([Created Month]@row = "8", "AUG", IF([Created Month]@row = "9", "SEP", IF([Created Month]@row = "10", "OCT", IF([Created Month]@row = "11", "NOV", IF([Created Month]@row = "12", "DEC", ""))))))))))))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives