-
COUNTIF one field or another has a value across a row
I need to count how many tests have at least one result without counting all of the results for each row. For example, in the chart above I have 5 tests. I need to know how many of those have at least one result, but not count the total number of results. In this case I have 4 tests that have at least one result. How can I…
-
Counting one column when criteria from another column is met
Hi! I would like to count the number of cells in one column that is not blank when another column is "HR" or "SURVIVOR". My current formula is below and is returning a #UNPARSEABLE error. =COUNTIFS([APP./RETURN DATE]:[APP./RETURN DATE]), <> "", [RISK?]:[RISK?], "HR", "SURVIVOR") Thank you! Thu
-
Help with formulas to summarize data from multiple sheets
Hello, I have a Blueprint set up in Control Center that is used to provision new projects. I want to add a sheet to my template set to compare projected direct labor from the schedule we have set up with the actual direct labor we have feeding in through Data Shuttle. The schedule is set up with phases as the top level and…
-
Create a Formula to count Working Days between a Due Date and Current Date
Hi There, I have figured out the Formula NETWORKDAYS. It is doing what I ask, BUT it if I drag the formula down it want to take the next row at Column - Today Date. I tried putting a $ sign like you would do in Excel to lock the formula on the one cell. As shown below but it's not locking to the 1st Row at Column - Today…
-
Can information be pulled to the primary column of another sheet?
We have a ‘central repository’ Smartsheet which lists all of our clients and pertinent client data. Each client has a unique client ID in the primary column, which is used in “Index/Match” formulas to bring specific client data to other sheets. When we add new clients to the repository, we must also manually add the client…
-
What is the formula for a cell using a few inputs based on a Part #
Please see below. What I'm trying to do is write a formula for the Remaining column to calculate Footage minus the absolute value of Starting # minus Ending # based on the Part #. For example, Part123 has the following: Footage = 10000, Starting # = 5000, Ending # = 3000 Remaining should be 8000. Then the next line for…
-
Adding one word in front of selections in multi-select dropdown column
Anyone know of a formula that would do what I've manually done in the screenshot below? I'm trying to add one word in front of each multi-select option selected and put into a new column.
-
Counting how many cells have any of some multiple options in them per column
Hi everyone..... I'm so close but so far. I want a formula that sums how many times each cell has any of several options in them. My pseudo-code: Look at all the cells in a column. If a column's cell has A, B, or C in it or any combo of A,B or C, count it as 1. Count all the cells and tell me how many cells have either A,…
-
Index Match(Or Collect) with IF, LEFT, and LEN
I need help combining 2 formulas that currently work on their own but I need them to work together. SHEET 1 - IMPORT SHEET (Data comes in as "100h") I can do the following to get the results I want. =if([Column1@row]="",0, LEFT([Column1@row], LEN([Column1@row] - 1)) I get a 0 if Blank or the "100" without the "h" SHEET 2…
-
Can I create a column function where all tasks & subtasks under the parent display specific text?
I've reviewed =PARENT(Task@row) but it only displays the immediate Parent label. I want all children and grand children to either display "specific text" or to display the contents in the grandparent row, is this possible? =ANCESTOR didn't seem to work based on what I could find. Example "Monday" is the Grandparent.…
