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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!