Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
IF OR Formula
I'm trying to come up with a formula that if the user selects either one choice or multiple choices in the same category it will equal the same or highest amount.
For instance:
Dog, cat = 3
Mouse, rat = 2
Snake, lizard = 1
If a user selects dog it needs to equal 3. However, if a user chooses dog and cat it also equals 3. The last example is if a user selects dog and lizard it will equal the highest amount of 3.
Having problems coming up with a formula for this. Any help on this would be greatly appreciated.
Answers
-
Hi @KCope21,
Your formula would look like this:
=IF(OR(HAS([Animal dropdown]@row, "Dog"), HAS([Animal dropdown]@row, "Cat")), 3, IF(OR(HAS([Animal dropdown]@row, "Mouse"), HAS([Animal dropdown]@row, "Rat")), 2, IF(OR(HAS([Animal dropdown]@row, "Snake"), HAS([Animal dropdown]@row, "Lizard")), 1)))
Sample data/output:
Hope this helps, but if you've any problems/questions then just let us know!
-
=IF(OR(
CONTAINS("cat", Animal@row),
CONTAINS("dog", Animal@row)), 3, IF(OR(
CONTAINS("mouse", Animal@row),
CONTAINS("rat", Animal@row)), 2, IF(OR(
CONTAINS("lizard", Animal@row),
CONTAINS("snake", Animal@row)), 1, "")...
-
Tried this and its coming back as unparseable.
-
Also tried this one and its coming back as unparseable.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to calculate how many Open items a business analyst has that are in the critical category, this is the formula i am trying to use but i must be doing something wrong Open equals = To Do, I…
- I have a SUMIFS statement that I am trying to calculate a total of $ if it meets two criteria from another sheet. I am looking for it to meet the criteria of RRC Status: Engaged and RRC Pathway: Essen…
- After much research, I am still stumped. I have set up a Smartsheet that will allow users, via a form, request a date and time slot for hoteling (work desk reservation). I have a link in the form to t…