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

Kelly Moore

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")

RonH

On Development Planner it returns "True" for the RB Status Column

And fascinatingly, the formula for the project sheet returns unparseable.

Kelly Moore

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")

Kelly Moore

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