I have a column with a finish date. In another column I’ve used a formula to pull out just the year.
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?