-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Formula help or advice if possible
Hi, i am hoping some can help or confirm if this is possible. The background: We are capturing data from employees working at 400+ locations. this is being done by a form. the data captured on the form is then being pushed out to individual sheets using a cross sheet formual: =INDEX({Employee Communications for Tupe Range…
-
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…
