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)

Find more posts tagged with

Formulas

Ivan -

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

Sean

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…