References in IF Formulas

[Nate_Sheets]

Can you do simple references within formulas?

Current formula:
IF({Frequent escalation?} = 1, “However, {he/she} frequently escalates, and so {he/she} needs a significant amount of support.”, “{C He/She} does well there with minimal supervision and supports by adults.”)

The formula is working, except the pronouns are not. They are of course referencing other formulas, and there is a checkbox called “Frequent Escalation?”

If not (siiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiigh) any suggestions on how to get around this? I am eventually wanting to get to more advanced texting formulas, but need to figure this out! Thank you so much!

[ScottWorld · Accepted solution]

Since you are putting your pronoun field names within quotation marks, it’s just resulting in literal text. The quotation marks indicate a literal string of text.

So, you would need to concatenate the strings of text and fields together like this:

"However, " & {he/she} & " frequently escalates"

[Nate_Sheets]

Yay! Thank you, Scott! I am optimistic again :grinning_face_with_big_eyes: