I am trying to reference a multi-select drop down in an IF formula.
I am create a formula where when two certain items from a mutli-select dropdown are selected, the formula will return 12.5, All other options or combination of options return 0.
I cannot get the reference right for having two options selected.
Answers
-
Try something like this:
=IF(AND(COUNTM([Column Name]@row) = 2, HAS([Column Name]@row, "The client has entered sales receipts instead of invoices."), HAS([Column Name]@row, [The client has marked the invoices paid in full.")), 12.5, 0)
-
@Paul Newcome Thank you. This was closer than I had gotten, however, it is still erroring for me.
When I use this formula, I get #UNPARSEABLE. `
When I use the second screen shot, I get #INCORRECT ARGUMENT SET.
Any ideas where I am mis-stepping?
Thank you!
-
Your first formula is correct, however you have too many parentheses added in.
See how after the AND( you have AND(( < you only need one ( after AND, not two.
Remove the pink one... then you'll need to also remove the pink closing ) before the , 12.5:
so there's only two here > )), 12.5, 0)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. & @Paul Newcome Thank you both! Together you helped me resolve this issue.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!