IF Drop Down options with same equation???
Hey there,
I'm having trouble solving this equation. I have a series of dropdowns all pulling VLOOKUP numbers which is then making the same equation. There are three options in the drop down. My equation works if I have only one "Price Group" Option but when I have more the equation stops working.
Any help!!???
=IFERROR(IF([Upholstery Price Group]@row = "Price Group 01", [Upholstery Price Group]@row = "Price Group 02", [Upholstery Price Group]@row = "Price Group 03", [Upholstery Price (DKK)]@row * [Consumption (RM or SM)]@row, IF([Upholstery Price Group]@row = "Open Price", [Open Price (DKK)]@row)), "0.00 kr.")
Thanks in advance.
Best Answer
-
Ok. I think I understand what you're going for now. You will need an OR statement, or we can shorten things up a little bit using an AND statement or rearranging the IFs.
My suggestion would be...
=IF([Price Group]@row <> "", IF([Price Group]@row = "Open Price", open_price_calc, specific_price_calc))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you able to provide screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes of course @Paul Newcome.
-
How is it supposed to be working? Is the Price Group column a multi-select dropdown?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes,
- Choose the price group via drop down.
- Price pops up
- You can also choose 'open price' at the bottom of the drop down list if you want to override the VLOOKUP. You can then put any price in the override cell.
- The consumption price is then calculated Upholstery price * Consumption (RM or SM).
I'm looking for the correct formula so any of the drop down price groups still calculate the upholstery * the consumption amount.
Not sure if that uses and IF(OR formula or am just missing something.
Thanks
-
Ok. I think I understand what you're going for now. You will need an OR statement, or we can shorten things up a little bit using an AND statement or rearranging the IFs.
My suggestion would be...
=IF([Price Group]@row <> "", IF([Price Group]@row = "Open Price", open_price_calc, specific_price_calc))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hey Paul,
Got it! Forgot the other IF statement the first time around.
Thanks for the help!!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!