Google Spreadsheet Post #1809
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct-29-2014
post by Zac622:
(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.
https://docs.google.com/
Thank you.
-------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment