Contains
![Kelly R.](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hello,
I have a vault number (EX: PB01ALL-PRS-0035-Complete) that contains the word Complete or In process and I would like my formula to return only those vault numbers with the word 'In Process' but for some reason my formula is seeing all the vault numbers and NOT just the ones that contain the word 'In process'.
Any suggestions for my formula - =IF(CONTAINS("Inprocess", [InfoCard Vault]:[InfoCard Vault]), "In Process", "")
For reference my Vault Number Column is text and the column the formula will pull the result in is a dropdown.
Thanks,
Kelly
Best Answer
-
Hi Eric,
I ended up figuring it out. I needed the formula to look @row vs the entire column. Appreciate your willingness to help.
Kelly
Answers
-
@Kelly R. Can you provide a screenshot?
-
Hi Eric,
I ended up figuring it out. I needed the formula to look @row vs the entire column. Appreciate your willingness to help.
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!