Multiple dropdown selection and perform some operation

Options
edited 03/20/23

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

• ✭✭✭✭✭✭
Options

So you want to divide the Stipend Amount by (5,000 * number of selections)?

Give this a try:

=[Stipend Amount]@row / (5000 *COUNTM(Semester@row))

• Options

no i have solve it but if there is any alternative way for this formula

=IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer I"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 12, IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer I")), [Stipend/Award Amount]@row / 11,

IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 11,

IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer I"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 11,

IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring")), [Stipend/Award Amount]@row / 10,

IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer I")), [Stipend/Award Amount]@row / 6,

IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 6,

IF(AND(HAS(Semester@row, "Fall")), [Stipend/Award Amount]@row / 5, 0))))))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!