With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, September 8, 2012
yogi_Pull Data From Sheet1 Ordered By Pending First Then Date Received In Ascending Order
I have a job board spreadsheet for a printing company i work for. I'm trying to create a filter formula that will filter the dates to list the older jobs that have not been finished, by oldest dates to newest (I have a column that will be entered with "finished" or "Pending"). I am so new to formulas, was seeing if i could get a little advice on how to maybe accomplish this.
I would like to filter the data by date received and the status of "pending" so i can see the important jobs that need to be completed by my company first over later received jobs. The "DATE COMPLETED" column would have either pending or a completed date. If it has "PENDING" i would like it to filter those jobs by the Date received (oldest to newest). Any help to accomplish this would be greatly appreciated