-
Counting the amount of entries from from entries
Hi, is it possible to capture the amount of entries that have come in from a form? the form is constantly being populated so i am looking for a live number if possible? Any help appreciated. thank you Dave
-
Help counting entries on another sheet
Hi, I am trying to count the amount of entries of another sheet that match the name of a row on my master sheet. I have tried to do something with count Ifs and match@row but have got a bit lost. So on my master sheet i have the name Basingstoke, beside that i have added a column saying how many times this appears on my…
-
Formulas for using the symbols
Hello - I love the new symbol options for the columns. I'd like to use use the up / down arrows to help me track some $$ to budget info. I have been trying to figure out which formula to use via the templates and I can't sort out how to do it. I know I can use conditional formatting to accomplish something similar, but I'd…
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Creating Pie Chart with Non-numeric values
Hi, I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I look…
-
Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn green and if it was > than to turn the cell…
-
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
-
Formula to check if cell contains text string + value in another cell
For example, the value in column 4 row 2 is "xxxxx_email address=test@test.com_xxxxx" The value in column 2 row 2 is "test@test.com" I need a formula that checks if column 4 row 2 contains "email address=test@test.com" by crosschecking the value in column 2 row 2 and using the text string "email address=" I have it worked…
-
Furmula Not Working Properly
In the following Formula if I use ="Completed" I get the correct Count back. If I change it to <> "Completed" I get 0 returned where it should be 37. =COUNTIFS(Status:Status, <>"Completed", [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3)) Any ideas? Thanks, Bill
-
if - and formulas auto populating checkbox
I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout. Any help is great! thanks in…
