Pulling Information into another sheet

I am trying to pull "Project Name" and Project ID" from our intake sheet into our Project Medtadata sheet. I tried using a formula but doesn't seem to work. Here's what I used. =INDEX(Portfolio:Portfolio[Project ID], MATCH([@Project Name], Portfolio:Portfolio[Project Name], 0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!