I have visualizations that pulls data from a Google Spreadsheet. One of the columns has the following formula.
=ARRAYFORMULA(IF(G2:G= "Value X", 0,IF(G2:G="Value Y",1,IF(G2:G="Value Z",1) ))) (arrayformula used to allow the calculation to expand as data is added). When I have the Goog spreadsheet open, the visualization is produced properly (and a table view displays the correct values). When it is closed, I get a timed out error (and the table displays empty cells for this column). This continues if I modify the formula to; =IF(G2:G= "Value X", 0,IF(G2:G="Value Y",1,IF(G2:G="Value Z",1))) Questions/Comments 1. Is there a way to pull results of a formula from a google spreadsheet that isn't open? 2. I have seen some people suggest that you can copy the 'values only' into another column. This wouldn't work since the spreadsheet is constantly and automatically updated and therefore I would either have to manually do this X times/day since the other option of =G2:G is also a formula (and would run into the same problem). Any help would be much appreciated. Thanks -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
