change drop down value on the certain date

Options

Hello, is it possible to automatically update a drop-down menu values on a certain day of the year?

for example, we have the following values in a drop-down menu. Each year on June 30, our Chief Residents graduate and each of the new years move up and 5 new incoming interns become PGY1.

so I need all Chiefs to switch to Residents Alumni, PGY4 01-06 to Chiefs 1-6 and so on. Also, some years will have an uneven number - in some there 6 or 4 but mostly have 5.

We're currently doing it manually.

thank you,

  • Chief Resident 1
  • Chief Resident 2
  • Chief Resident 3
  • Chief Resident 4
  • Chief Resident 5
  • Chief Resident 6
  • PGY4 01
  • PGY4 02
  • PGY4 03
  • PGY4 04
  • PGY4 05
  • PGY4 06
  • PGY3 01
  • PGY3 02
  • PGY3 03
  • PGY3 04
  • PGY3 05
  • PGY3 06
  • PGY2 01
  • PGY2 02
  • PGY2 03
  • PGY2 04
  • PGY2 05
  • PGY2 06
  • PGY1 01
  • PGY1 02
  • PGY1 03
  • PGY1 04
  • PGY1 05
  • PGY1 06
  • Research Y2 01
  • Research Y2 02
  • Research Y2 03
  • Research Y1 01
  • Research Y1 02
  • Research Y1 03
  • Resident Alumni


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!