Skip to main content

Extrapolating year formula

  • February 24, 2020
  • 2 replies
  • 49 views
E
Forum|alt.badge.img+1

Hi All

I have a column with a finish date. In another column I’ve used a formula to pull out just the year.

So:

Finish Date (column): 2/20/2020
Year (column): 2020

If I don’t have the finish date inputted the column shows #error!..i know it’s working because when I add the date to the Finish Date column the Year populates correctly.

What I would like to do is if there is a date in the finish column, then pull the year from that date to show in the Year column, however if the Finish Date is not yet entered, I’d like to have the Year field show something like “not done yet” is there a way to do this?

Thanks
Emma

    This topic has been closed for replies.

    2 replies

    JonathanBowen
    Forum|alt.badge.img+18

    Hi @Emma_Sousa - you can do something like this:

    IF({Finish Date}, YEAR_FORMULA_HERE, 'not done yet')

    JB

    Edit:

    Specifically:

    IF({Finish Date}, DATETIME_FORMAT({Finish Date}, 'YYYY'), 'not yet done')

    E
    Forum|alt.badge.img+1
    • Emma_Sousa
    • Author
    • Known Participant
    • February 24, 2020

    Hi @Emma_Sousa - you can do something like this:

    IF({Finish Date}, YEAR_FORMULA_HERE, 'not done yet')

    JB

    Edit:

    Specifically:

    IF({Finish Date}, DATETIME_FORMAT({Finish Date}, 'YYYY'), 'not yet done')


    Awesome!!! Thanks so much.

    Emma

    Terms & ConditionsAccessibility statement