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, October 28, 2014
yogi_Count The Number Of Times A Title is Submitted Accepted Rejected
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/vz_TPOzvbO0) I have values that are either accepted, denied or pending. How do I count each?
I know next to nothing about google spreadsheets or excel so I'm learning as much as I can. Here is my problem.
Background: I'm a creative writer and I want to track where my pieces get submitted to, how many times they get submitted, how many times they are accepted/rejected and when. I have most of that working for me but...
Right now I have it so when I enter the title of something, it adds it to a list and starts counting how many times that title occurs which works great.
However, I need to manually enter when a piece of mine is accepted or rejected, and until I enter one of those, it automatically puts it as pending and starts counting how long it has been since I sent something in. The problem I have is that I want to be able to see in my list how many times something is accepted AND rejected AND how many are currently pending.
I simply cannot figure this out. The problem comes within the fact that the data I enter for new titles will be in random locations. Can someone help please I've wracked my brain for three days.