-
VLOOKUP Doesn't Appear To Work With Auto-Number Columns/Cells
I have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track projects tasks and want to be able to link a task to its associated project in the project sheet. There are select columns…
-
I need to collect the average of a column by referencing name in another column
I have columns in a sheet per the screen below. The Team Member is input through a form submission and can potentially be input many times. I am looking for a formula to collect the average score from all rows where one name appears without having to say ="Scooby Doo".
-
SUMIFS Issue
I have a fairly straightforward formula that i cant get to work, driving me crazy! I typically prefer Sumifs over Sumif but currently I am summing a kpi column of numbers if two additional columns (both Text/dropdown (single Select format) report a specific set of words. what am i missing!?! Thanks in advance. =SUMIFS([KPI…
-
Sumifs to count color symbols
Hello, I have a spreadsheet where I am tracking initiatives by team for each month and there is a color assigned to that initiative. For each month I assign these colors. I have a total of 12 columns. Green for on track, Yellow for at-risk, Red for breached, and Gray for not started. I really wished I could add one more…
-
Count if
Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting…
-
Formula not updating
I have a very simple formula. =[Unit Price]@row * Units@row. It is suppose to take the unit price cell in the row and multiply it by the units cell in that same row. 9 times out of 10 it works fine, but every once in a while it wont update. This is causing us invoicing issues within out company as we have to go back and…
-
Count only child rows that have "Complete" in 3 columns
Hi I am trying to count the number of child rows that have "Complete" in 3 different columns. Here is my current formula: =COUNTIFS((CHILDREN)1, [HS Germ]:[HS Germ], "Complete", [HS Pave]:[HS Pave], "Complete", [Classroom]:[Classroom], "Complete") I keep getting "UNPARSEABLE". Any suggestions?
-
Count how many times a word appears in a range of cells
I am trying to use a cross sheet formula to count how many times specific words in a range of cells. I keep getting a 0 and not sure why. Any direction will be greatly appreciated. Below is the formula I used. =COUNTIF({Touch Log - Detail Range 2}, FIND("Call", Submitter@row) > 0) I hope that the screenshots help.
-
Returning a status if one cell within a range meets criteria
Hi, I am tracking some metrics using RYG balls. I have several parent metrics and child metrics under those all with RYG balls for a status. I would like the parent RYG ball to show red if at least one of its child metrics is red, yellow if at least one metric is yellow, and green if all are green. Does Smartsheet have…
-
How do I get a word count on a range of cells?
How do I get a word count on a range of cells? (Note: In the examples below, the text I need a word count on is in a column called "English" and the text I want to count is in rows 12 to 103.) I can get a word count on 1 cell using this formula: =LEN(English12) - LEN(SUBSTITUTE(English12, " ", "")) + 1 I tried replacing…