Calculated field on Selection of another field.

Forum|Forum|2 years ago
July 13, 2023
2 replies
1316 views

I want to set up a calculated field to have a pre-set value based on a selection of another field (radio button). So suppose one radio button have 4 options a,b,c and d, I want to have a calculated field that shows 1 for a, 2 for b, 3 for c and d.

Is it possible?

Thanks,

Nisha

Workfront

Best answer by NishaPatel

Thanks, this is working for me 🙂

K

Karlton_Harrison

Employee

Fields:

Radio Type = A, B, C, D

Calculated field =

IF({DE:Radio Type}="A","1",
IF({DE:Radio Type}="B","2",
IF({DE:Radio Type}="C","3",
IF({DE:Radio Type}="D","4"))))

N

NishaPatelAuthorAccepted solution

New Participant

Thanks, this is working for me 🙂

RandyRoberts

New Participant

This is possible but the caveat is the form has to be refreshed before any calc takes place. This is usually done by selecting "Recalculate Expressions" from the elipsis menu on the Project.