Jan 18, 2023 06:47 PM
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
Jan 18, 2023 07:04 PM
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
)
Jan 18, 2023 07:48 PM
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!
Jan 19, 2023 09:11 AM
Screen shot?