Help

Invalid formula error

1818 3
cancel
Showing results for 
Search instead for 
Did you mean: 
RS
4 - Data Explorer
4 - Data Explorer

Hello, I am new, and new to using airtable.

I have a problem with syntax in a simple formula that is vexing me. All the field names are correct

Donor Capacity = (Estimated Capacity  * 0.5) + (Annual Fund Likelihood * 0.2) + (Major Gift Likelihood * 0.2) + (Philanthropy * 0.1)

 

Thank you!

 

RS

3 Replies 3

Put the names of all of your fields in curly braces {}. Curly braces are required for field names with spaces and other special characters. Technically curly braces are not required for single word field names, but it is good practice to include them anyway. I also like a multi-line format for this type of formula.

Is {Donor Capacity} the name of your formula field? If so, you also need to leave that out, as well as the equal sign.

SUM(
  {Estimated Capacity}  * 0.5,
  {Annual Fund Likelihood} * 0.2,
  {Major Gift Likelihood} * 0.2,
  {Philanthropy} * 0.1
)

RS
4 - Data Explorer
4 - Data Explorer

Hi, and thank you very much. I must be a doofus, since I don't understand why it comes back with "formula fields should be configured in the field menu dropdown"

I'm missing something.

Thanks!

Screen shot?