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?