Contains
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
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!