Automatically change a multi-text field upon the input of date

  • 1
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Hi all,

I'm trying to do an automatic change of Text-Multiple Choice based on the date entry.

For example,

[Text-Multiple Choice] has 4 options -> 1st/ 2nd/ 3rd/ 4th

If [Date 1] is filled, change [Text-Multiple Choice] to 1st
If [Date 2] is filled, change [Text-Multiple Choice] to 2nd
If [Date 3] is filled, change [Text-Multiple Choice] to 3rd
If [Date 4] is filled, change [Text-Multiple Choice] to 4th

Additionally, [Date 2] should have precedence over [Date 1], [Date 3] over [Date 2]........

Right now I want to use the Kanban report to track some of the processes going on, I can only choose the card groups based on [Text-Multiple Choice]. Furthermore, the formulas for Date fields are only based on "today", "day(s) in the past", "tomorrow", etc.

Any help would be appreciated!

Thanks.
Photo of Samuel Goh

Samuel Goh

  • 382 Points 250 badge 2x thumb

Posted 1 month ago

  • 1
  • 1
Photo of Jordan McAlister

Jordan McAlister

  • 550 Points 500 badge 2x thumb
I don't think Multiple Choice has a formula field version, but you could set it as a formula text with this formula (not tested):

If(
not IsNull([Date 4]), "4th",
not IsNull([Date 3]), "3rd",
not IsNull([Date 2]), "2nd",
not IsNull([Date 1]), "1st"
)

In this case, it will check [Date 4] first and if its filled in, it will output the text you want in place of "4th."

If you still wanted it to be a multiple choice field, you could set up an automation or action for this where when [Date *] gets filled in, input "1st, 2nd, 3rd, or 4th" in your multiple choice field, but that won't have the precedence requirement, so I think the formula text is your best bet if you want it to be completely automated.