Logical test on linked data

[Guest]

My 2007 spreadsheet has a link to a CSV file. It brings the entire CSV into
the spreadsheet. I wanted to create a new column outside of the linked
region that tested the condition of one cell and returned a result.
Unfortunately it doesn't return the result but displays the test function
itself.
So in the cell I now get
=if(Table_owssvr_13[[#This
Row],[Status]]="Completed",10,if(Table_owssvr_13[[#This Row],[Status]]="To Be
Created",3,6)) instead of the answer to the test. What am I missing here?

 

[David Biddulph]

I don't understand your syntax.
Where you've got
Table_owssvr_13[[#This Row],[Status]]
there should be a reference to a cell.
I don't know 2007, but that doesn't look like the sort of cell reference I'm
used to seeing in Excel 2003.

If in the formula bar you type =, then click in the cell to which you are
referring, what reference do you see after the = in the formula bar.

 

[Guest]

This is the new way Excel refers to cells within a pivot table. It's a
relative reference. I know it looks weird but thats the way it comes out
when I create the function using my 15 years of using Excel.