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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 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!