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
Answers
-
@Jörg Schmidt1 I think I know what you are asking. If what you are looking to match will only result in one unique match, does this help?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
You are going to need a SUMIFS along the lines of...
SUMIFS({Range To SUM}, {Range To Match On}, HAS([Multi-Select Column Name]@row, @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!