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 “
I have a Calculated field with field code “
I input the following formula into the Calculated field that reads:
However, it results in the
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
Please, any help you can provide would be great!!!