PMO Template - Deleted header row
Hi guys!
I’ve been using the PMO template successfully for a while now, but this morning I accidentally deleted the Header info and now all of the metadata for the projects shows #REF for all of the fields.
I tried to recreate it as best as I could, but it’s still off. Attached are what they look like. Normally I’m the project metadata, I enter the project ID and the index match would fill in the blanks.
here is the existing formula that is tied to each metadata right now.
Project Name
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Name]$1, {Portfolio Summary Header Row}, 0))
Project Category
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Category]$1, {Portfolio Summary Header Row}, 0))
Project Manager =INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Manager]$1, {Portfolio Summary Header Row}, 0))
Target Start Date
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Target Start Date]$1, {Portfolio Summary Header Row}, 0))
Target End Date
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Target End Date]$1, {Portfolio Summary Header Row}, 0))
Answers
-
Hi @andreww
Once you've added back in a row at the top with the header information, you'll just need to go into your formulas and update the {reference} that looked at the previous header row, and now point it to the new header row.
I'll bold the reference:
=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Name]$1, {Portfolio Summary Header Row}, 0))
Click "Edit Reference" then find the header row again and click on the row number to highlight the entire row. This should now update all of your other formulas in the same sheet to have the correct reference.
Let us know if this worked for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!