Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to write an app where it counts the number of lines by person
Say everybody is listed and has multiple entries, but I want to click around and see it change. I know if you do =count(owner) and then click in the GUI, it will move around, but can I make it do =count(owner "when clicked") or something like that? so it knows it's looking for a click?
What do you mean by 'number of lines by person'? The number of rows in a straight table? What are they clicking? A person?
yes, column "Owner" is one of my objects. If they click John Q. Public, I want it to count how many times his name appears in the table.
Like in a text box? Here is my first thought, do you have a unique value like in this instance, ProjectID on the table?
=if(COUNT(DISTINCT Owner) = 1, COUNT(ProjectID), '')
no but I can get one added very very easily, and it wouldn't detract from what I'm trying to do. I'll give it a shot, thank you!
Sure, and if it is in a straight table, you shouldn't need to add that new value to the straight table, just use it in the code for where you are trying to display the count