0

I am trying to make the following happen on a list: If a user selects "Most" as a choice, then another column will return as 1. If a user selects "Somewhat" then that column will return a .5. If a user selects "None" then that column will return a .0. Any advice on the formula syntax?

1 Answer 1

1

In a calculated column,

IF([ColumnA]="Most","1",IF([ColumnA]="Somewhat",".5",IF([ColumnA]="None","0",NULL)))

[ColumnA] should be changed to the name of your column.
NULL can be changed to a default value if nothing is selected.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.