Curreny Year Checkbox
Please help.
I have been using this formula to check a box if the date the employee left is the current year but it is still only counting 2022 and i need it to be the current year..
=IF(YEAR(TODAY()  DAY(TODAY())) = YEAR([Last Day of Employment]@row), 1, 0)
Best Answer

Hi @Katie B
I'm not sure why you have the DAY portion of your formula; if you're after only current year showing then the following should work:
=IF(YEAR(TODAY()) = YEAR([Last Day of Employment]@row), 1, 0)
If you had a noncalendar year (e.g. July to June) then another formula would be required.
Hope this helps; if you've any questions etc. then just ask! 😊
Answers

Hi @Katie B
I'm not sure why you have the DAY portion of your formula; if you're after only current year showing then the following should work:
=IF(YEAR(TODAY()) = YEAR([Last Day of Employment]@row), 1, 0)
If you had a noncalendar year (e.g. July to June) then another formula would be required.
Hope this helps; if you've any questions etc. then just ask! 😊

That's worked perfectly!! Thankyou so much
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!