Multiple dropdown selection and perform some operation

Rushik Patel
Rushik Patel ✭✭
edited 03/20/23 in Formulas and Functions

i am having 3 field

Stipend Amount | Semester(dropdown with multiple selection) | value(want formula)

1)25000 | fall,spring(have selected multiple option in dropdown) | 2500(stipend amount/10) and if there is only one selection than (stipend/5)

2)25000 | fall(single value selected) | 5000(stipend amount/5)

need help to get value

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!