So I have this formula that is big (word says it's 64 words long). But it is essentially a repeating "if box is checked, add these characters to the front of the text"
so imagine If(and([box], text = "Text1"), "char/Text1", If(and([box], text = "Text2"), "char/Text2",
And so on.
What I would like is: If(and([box], text = "Text1" "Text2" etc, "char/whichever text"
is there a short way like that, or do I need to figure out ever possible iteration and add them all in?
Thanks for any help!