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

Tags:

Answers

  • Andrea Zenner
    Andrea Zenner ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!