Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

References in IF Formulas

Topic Labels: Formulas
Solved
Jump to Solution
295 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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"

See Solution in Thread

2 Replies 2

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: