-
Summarize child information in parent row?
Hi - I'm trying to write a formula that would group and summarize information from children rows into a cell in the parent row and I keep running into issues. I have a "Dropdown (Multiselect)" column for "Work type" that has the available values of Web Design, Copy, Video, Animation. Any row can be one or any of those…
-
Conditional Formatting with #No Match
Hi everyone, I've been working on conditional formatting utilizing the #no match on a formula (a vlookup that doesn't have a reference so we can add). I've like to have some cells highlighted (rows 1-12) when "no match" occurs, which is a possibility on the conditional formatting options, but highlights aren't happening.…
-
How to add minutes to a field containing a time?
Hello All I have a column that represents a Task Start Time (2:00pm) and I would like to add minutes (60) to that Task Start Time and get the results in a third column representing Task Stop Time (3:00pm), so three columns; Start Time, Duration, and Calculated End Time. Any help would be greatly appreciated!
-
INDEX/MATCH function doesn't return exact match.
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting from left to right, or top to bottom. "-1" should find the first value less than or equal to the…
-
Change the year of the date when the type of the column is date
Hi, I want to create automation that sends alerts on the day before birthday dates for someone specific. I create a birthday column that is defined as type date. The problem is when the year is past, the year on the date does not update automatically and then I need to update the year. How can I create a formula that…
-
formula checkbox referencing contact field problem
I am a newbie trying to check a formula checkbox if one of two names or both names are in a contact field list. Why isn't this working? =IF(CONTAINS("Name1", contact@row), OR(CONTAINS("Name2", contact@row), 1, 0))
-
Average days open
=AVERAGEIF([Closing Date]:[Closing Date], "", [Days ago]:[Days ago]) Im trying to average the amount of days a case is open by selecting the rows that have a blank closing day which means that they still open. but i keep getting #INVALID DATA TYPE thank you in advance
-
Checking Complete based off various criteria
I am hoping someone can help me. I want to make the Complete column a column formula column in my Project Tracking sheet so that I don’t have to babysit and mark every line (we have hundreds) for when a package is completed but I can’t get my formula to work. Here is what I have for my current formula: =IF([Go-Live…
-
interactive Dashboard
HI All! I'm trying to create a dashboard where my team can go and select a model number from a drop down, and the dashboard would then display all the features and functions of that particular model. Is there anyway this can be accomplished? Alternatively, is there anyway I can automatically generate a document from…
-
How do I calculate the sum of children rows only when their corresponding "checkbox" is unchecked?
Hi, I'm creating a sheet to track the progress of a photoshoot. I want my "Price2" cell to total the cost of children rows "Price2" and "Price3", etc. The cost will only ever be $47.40 or $0. (When the check mark is enabled, it indicates the photo has been taken, and therefore removes the associated cost). I want the total…
