Checking a box if current month
LisakayS
✭✭✭
Hello,
I am trying to check a box if the "Next MI Date" is equal to the current month. Here's the formula I have but even when the "Next MI Date" is 02/01/2023 it is not checking the box.
=IFERROR(IF(MONTH(TODAY()) = MONTH([Next MI Date]@row), IF(YEAR(TODAY()) = YEAR([Next MI Date]@row), 1, 0)), 0)
What am I missing?
Thank you,
Lisakay
Answers
-
=IF(MONTH([Next MI Date])=MONTH(TODAY()),TRUE,FALSE)
It is possible that the date format of the "Next MI Date" column is incorrect, which is causing the formula to not work as expected. To resolve this issue, you can change the date format of the "Next MI Date" column to "MM/DD/YYYY".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!