Curreny Year Checkbox

Options

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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“
    Options

    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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“
    Options

    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! 😊

  • KatieB
    KatieB ✭✭
    Options

    That's worked perfectly!! Thankyou so much

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!