How to pull data from another Google Sheet

February 6, 2014

Use this in a google spreadsheet =Query(Projects!A1:P999, "select A, B, C, D where C = 1")

This spreadsheet has a sheet called "Projects" that another sheet pulls data from.