Formula returning Invalid Column Value
Hello,
I'm struggling with a formula that is returning an in valid column value error. All columns are Text/Number.
Sheet 1 has one row for each project. Sheet 2 has a column that may have multiple project numbers in the same field. I need to return the value in the Status field (which is a drop down) if the project number found in Sheet 1 is contained in the project number(s) column in Sheet 2.
I thought the issue might have been the pick list column so I created a helper column called Status Text that pulls the status from the pick list column. (Formula is just =Status@row)
This is the formula that is returning the error. What am I missing? Am I not using contains correctly?
=IF(CONTAINS([Project Job Number]@row, {Project Job Number}), {Status Text}, "Not Found")
Thanks much!
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Answers
-
I was being silly. I didn't need the contains part, I could use a simple INDEX/MATCH. This is answered.
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 285 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!