Hello, I am trying to create a calculated column that looks at the Expiration Date and pulls the year into the new column. I have this formula =IF(ISBLANK([Date]),"LegalHold",TEXT([Date],"yyyy")) which is working great but now I need items that are expiring in Q1 (Jan-Mar) to get the previous year. Example:
| Date | Legal Hold Date | Year |
| 5/13/2024 | | 2024 |
| 2/14/2024 | | 2023 |
| | | LegalHold |
| | 7/11/2024 | 2024 |
Can someone help me revise my current formula of =IF(ISBLANK([Date]),"",TEXT([Date],"yyyy")) to enable this?
Also, if there is a legal hold, the Date will be blank, and there may or may not be a Legal Hold Date. If there is a Legal Hold Date, I would like to pull in the year for the Legal Hold Date instead of just typing Legal Hold.
