Project Meta Data Formula

Tess H

Hello,

I am using the PMO template set and somewhere along the line while customizing my project metadata sheets started referencing the wrong cells in my Project Intake Sheet. They reference the correct row associated with the project ID, but they are not pulling the information from the right columns.

I have checked all my column headers and my column header rows and they match, however the cells linking into the my metadata sheet are referencing the columns directly to the left of the correct column in the Project Intake sheet.

I updated the Portfolio Summary Data reference to reference the whole Project Intake sheet, and now the column references are off by two columns to the left.

Does anyone have an idea how to fix this, or what went wrong?

Andrée Starå

Hi @Tess H

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!