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.
Tuesday, February 20, 2018
yogi_From MASTER Sheet Create Sheet For Each SubCategory by TYPE
question by: Eliza J https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/2mjCBsjKMfQ;context-place=mydiscussions
Have Categories Sorted Into Subsheet, EXCLUDE based on 1 field
Hi all -
I have set up this spreadsheet to sort into the Subsheets based on "TYPE" from the master list. I would like a 2nd level of sorting, which would tell it to EXCLUDE any field from the MASTER that has "NO" Listed under "PREFERRED".
For Instance, only TYPE: "PHOTOGRAPHER" + PREFERRED: "YES" Would sort into the "PHOTOGRAPHER" Subsheet.