Skip to main content

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!

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"

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"


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

Reply


Terms & Conditions