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 non-calendar 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 non-calendar 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!