Hi everyone,
I’ve got a table that I’m having trouble with. In the “Act” column, I have a single-select with Act 1, Act 2, Act 3, and Act 4 as options. When one of those Acts is selected, I want the next column (“Act Dynamics”) to return a string of ...
Mohamed_Swellam:
SWITCH({Act}, “Act 1”, “Denial to anger;Rejecting opportunity;Ordinary world”, “Act 2”, “Bargaining and losing;Wanderer”, “Act 3”, “Bargaining and winning;Warrior”, “Act 4”, “Martyr”)
It works! Thank you so much, Mo!
