Here is the sheet I just made. Seems mostly ok except I can't get the Edgeryders Project Profit to come out the the (extremely close to) 20% the numbers indicate. I tried modifying the formula (=Cost!$H$26 / $B$14) but that didn't work.
And I am having trouble with Item 4: Fill down column B so that its =IMPORTRANGE($A…, "ProjectData!A4:G4") formulas cover the rows you added to the table.
I do not see that formula on the sheet so I can fill it down. I expected to see it in the column B header. Am I supposed to add it in?
"Grant access. You will now see a #REF! in the "Project Name" column. Mouse over it and click on the "Authorize" button that appears. This permanently allows the Magic Spreadsheet to access the placeholder spreadsheet (as long as you have access to the placeholder spreadsheet)."
That did not happen for me. Is this #REF! supposed to show up in the Overview?
I am sorry I am having such a difficult time with this. I have spent a lot of time trying to make sense out of it and keep coming up short. For a guy who handled big budgets in a variety of businesses, it embarrasses me to have such trouble with this..