Trending in Formulas and Functions
-
Combining selected cells into one cell ignoring blanks?
Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…
-
Using Parent Rows in Reference Another Sheet Formula
I'm attempting to calculate the total number of pediatric calls by county using this formula all referencing another sheet: =SUMIF(PARENT({MAHEC County}, "Buncombe"), {Pediatric Calls}) However, it is not working. Any suggestions?
-
Is there any way to pull in Date AND time to a column when a specific condition is met?
I've been trying to create a column that populates the date AND time when a condition from a different column is met. Is there a way to do this without creating any other sheets or extensive work? It seems like a very simple thing to do as they have a record a date workflow but it doesn't include time. Don't know how this…