Hello,

I am trying to create a “scoring matrix” of sorts using IF formulas, and not sure what exactly I am doing wrong.

I have a field with field code “`seniorstatus`

” and the Drop-down field allows for two responses “`yes`

” and “`no`

.”

I have a Calculated field with field code “`SeniorStatusPoint`

.”

I input the following formula into the Calculated field that reads:

`IF(CONTAINS(seniorstatus,"Yes"),"1","0")`

However, it results in the `#VALUE!`

error.

What am I doing wrong?

Also, I want to make a formula that assigns a point based on the age of the record.

I have the age of record formula set up and working at this time.

It is just the next formula I am not sure what to do.

Record 1 year old = 1 point

Record 2 years old = 2 points

Record 3 years old = 3 points

Record 4 years old = 4 points

Etc…

Please, any help you can provide would be great!!!

-Riot