Is it possible to link a column from one sheet to another?
Comments

Hey
Just as a quick test, and we can delete these formulas after the test, please copy the appropriate formula into a text number field on each respective sheet. This checks each value to see if smartsheet thinks it's a number. Make sure there is an actual value in the Request ID or Tracker Number on the row when you insert the formula. Your error is behaving like there is a mismatch.
For Development Planner
=IF(ISNUMBER([Request ID]@row), "true", "false")
For Project
=IF(ISNUMBER([Tracker Number]@row), "true", false")

On Development Planner it returns "True" for the RB Status Column
And fascinatingly, the formula for the project sheet returns unparseable.

Nope, my bad. Unparseable usually means a comma, parenthesis, quotes or other formula formatting error. I forgot the quote in front of false.
=IF(ISNUMBER([Tracker Number]@row), "true", "false")

Ok,
Let's see if this works. These are exactly the same ranges in your current formula. If I don't call them the right name, use the right name. I've only changed the smartsheet formula function, not your ranges.
=INDEX(COLLECT({Development Planner}, {Development Planner RB Status 7}, CONTAINS([Tracker Number]@row, @cell)),1)
Fingers crossed
Help Article Resources
Categories
Check out the Formula Handbook template!