Does not contain this or that TEXT
Hello,
We currently have a formula that works to say if the variation row contains E-Gift, the cell will say E-Gift Card and if it contains Physical Card the cell will say Physical Gift Card.
=IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card"))
This works. However, we want to add that if the cell in variation row does NOT contain the word card, it will say company product.
I Tried adding IF(NOT(CONTAINS("Card", Variation@row)), "Company Product") to the above formula and got #UNPARSEABLE
Any help is appreciated
Tags:
Best Answer
-
=IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card", IF(NOT(CONTAINS("Card", Variation@row)), "Company Product","")))
Answers
-
=IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card", IF(NOT(CONTAINS("Card", Variation@row)), "Company Product","")))
-
Thank you so much!! This is perfect!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives