Project Meta Data Formula



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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!