Calculating Values

Options
DB393
DB393 ✭✭
edited 08/09/23 in Formulas and Functions

New to Smartsheet here.

Background on what I am trying to do. I would like to count the specific words that were selected from a multi check box and then multiply the count with the $ amount associated with that text.

Example:

User selects: Apple, Banana, Orange, these (3) selected options then get displayed together in Cell A1 on the destination sheet.

In the source sheet I have Apple = $1, Banana= $2 and Orange=$3.

What I would like the formula to do is count the words in cell A1 then multiply that by the associated $ amount and sum the total in B1.

In this example the total amount would equal $6.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!