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

2»

Comments

  • Kelly Moore
    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
    RonH ✭✭✭

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

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

  • Kelly Moore
    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
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!