Project Metadata No Longer Pulling from Project Intake Sheet

Options

My project metadata in the project folder(template downloaded online) is no longer autopopulating when I put the Project ID in. For the last year it had been but now it isn't I am not sure if I am messing up the formula. HELP!

Answers

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭
    edited 08/10/22
    Options

    @Jess Trial In your formula screenshot, after Match(, you have a $. This must be deleted because you are using @row so there is no need for an absolute reference. Also, you cannot have 2 Matches in the formula. Referencing the project ID should be adequate.

    Melissa Boehl

    Smartsheet Architect | TurningPoint Energy

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭
    edited 08/10/22
    Options

    @Jess Trial Try this =index({project intake sheet name},Match([project id]@row,{project intake sheet ID column},0))

    Melissa Boehl

    Smartsheet Architect | TurningPoint Energy

  • Jess Trial
    Options

    @Melissa Boehl neither of those worked

  • Melissa Boehl
    Melissa Boehl ✭✭✭✭✭✭
    Options

    @Jess Trial I would be happy to work on this for you. The easiest way for me to identify the issue would be to work on the sheets themselves. Could you copy the workspace or sheets into a new workspace and share it with me? mboehl@withersravenel.com

    You can remove or alter the data if you like. Then I can play with it and try to identify exactly where the issue lies.

    Melissa Boehl

    Smartsheet Architect | TurningPoint Energy

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!