+1Hello, 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
+29Put 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
)
+1Hi, 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!
+29Hi, 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?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.