-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Date formula in content calendar template
I'm trying to copy the content calendar template into the rest of the months for this year. It has January filled out but the rest are blank. I'd like to have the week column updated to the correct dates for each week in the month. I can't seem to figure out the formula to correct the issue (you can see below the date is…
-
Combining Formulas to make one big Formula
I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the…
-
Formula to check off a box if date is in the past and not blank
This is one of the formulas I've tried: Thanks for your help!
-
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…