How do I update the year based on status change?
I want to have the year updated when the project status changes to Complete or Cancelled to insert the current year to be automatically updated in the Archive Year column. The column is currently set as a single dropdown with all the years listed, but I want to build a formula to automatically change the column to update when the project status changes. Do I need to change the dropbox to a text/number? I have a workflow created to move the row once a year when the Archive Year is for the prior year. I know it can probably be easy to setup a workflow on this, but I would like to use a formula to have the column updated for the current year whether its 2022, 2023, etc. based on the current year project is complete or cancelled.
Help Article Resources
Check out the Formula Handbook template!