Index / Match with multi select criteria

I use a price calculating sheet for various criteria f.e. client or not, booking on short or long term and so on. A possible client uses a form to answer the questions and the price will be shown in another sheet "lead management" and the price will be offered to the interested people by an automation process.

Is it possible to change the formula using multi select criteria - in the example sheet

column "Extras" a client would choose f.e. if he/she wants

  • accomodation (Unterkunft) = 1.449,42 € and also
  • food
  • beverages


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!