I would like to create a nested IF formula that will output text to the formula cell based on which option is selected in the single select field. This is what I have so far.
IF ({Single Select Field} = “A”, “Answer 1”, If ({Field} = “B”, “Answer 2...