-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
How to use "Countif" with reference to CHILDREN in another sheet
Hello - I need some help with the children formula. I am trying to reference another sheet and only pull info from the children of specific hierarchies. The only way that I can do it, as of now and with my current skill set, is if I select all of the actual children. I realize this will be out of formula as soon as more…
-
Formula Between Date
Can someone tell me what I am doing wrong in this formula? =COUNTIFS({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 3}"remediated") AND({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 4}<=(2018,6,30),>=(2018,4,1)) I am trying to count if Range 3 (Status) is remediated and Range 4 (date completed ) is between 2 dates.…
-
Having Trouble with SUMIFS
I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350, [Flight Type]1, "One-Way")…
-
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…