CONTAINS Formula

Hello,
I need help with this formula =IF(CONTAINS([Invoice Number]@row, "Invoice"), "Yes", ""). It worked if the "Invoice Number" row value is only "Invoice", if value contains "Invoice xxx" something else after "Invoice" it doesn't put "Yes" in "Want Yes" Row.
I would like to put "Yes" in "Want Yes" row if the "Invoice Number" row contain the word "Invoice".
Thank you.
Best Answer
-
Hello @BonW
I know what it's like to have people add anything into the cell so you as the Smartsheet god needs a work around. You may want to use a drop down if possible to limit the variables.
Anyway, Check out this formula:
=IF(FIND(UPPER("Invoice"), UPPER([Primary Column]@row)) > 0, "Yes", "")
I took the liberty of adding an additional probability and that's if your people type "invoice" using lower case. Currently, your formula only accounts for "Invoice" with a capital "I" and formula is case sensitive.
Good luck!
Michael
Projects Delivered. Data Defended.
Answers
-
Hello @BonW
I know what it's like to have people add anything into the cell so you as the Smartsheet god needs a work around. You may want to use a drop down if possible to limit the variables.
Anyway, Check out this formula:
=IF(FIND(UPPER("Invoice"), UPPER([Primary Column]@row)) > 0, "Yes", "")
I took the liberty of adding an additional probability and that's if your people type "invoice" using lower case. Currently, your formula only accounts for "Invoice" with a capital "I" and formula is case sensitive.
Good luck!
Michael
Projects Delivered. Data Defended.
-
It works! thank you very much Michael.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!