Project Metadata No Longer Pulling from Project Intake Sheet

Jess Trial

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!

Melissa Boehl

@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

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

Jess Trial

@Melissa Boehl neither of those worked

Melissa Boehl

@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? [email protected]

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.