Welcome!

Is there a way to use a countif formula if the cell reference is a formula as well?

Hi All,

Any help would be appreciated.

I get #NO MATCH when I run the below formula. Is it an issue with a formula referencing a formula?

="Not Completed: " + COUNTIF([Column3]2:[Column3]24, FIND("Not Completed", @cell) > 0)

Formulas

Ivan -

Can you provide a screenshot? I mocked this up and the formula is working fine using what you had provided.

Sean

Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
Sum Value Across Multiple Rows
I need to confiruge an average score between mulitple rows. The row value are determined by this formual =IF([Question 1]@row = "Strongly agree", "5", IF([Question 1]@row = "Somewhat agree", "4", IF([Question 1]@row = "Neither agree nor disagree", "3", IF([Question 1]@row = "Somewhat disagree", "2", IF([Question 1]@row =…
Generating Documents
Am I able to generate a document with children rows reporting out as rows? I want to make a header followed by multiple rows of data supporting that header.