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

INDEX/MATCH ERRORS
I have used the index/match formula successfully , but in my current project, for some reason it isn't working. I have my two sheets (Open Adp) and (A/N Referrals). In Open Adp, there is a Case ID and then a person's name associated with that ID. I'm trying to have the person's name from Open Adp sheet be pulled over into…
helper row and determining the earlier of 2 finish dates
Hello, I have task 3 which is dependent on task 2 and task 1. I want task 3 to start when either task 2 or task 1 is completed. How do i implement this in Smartsheet gov? below is a screenshot of what I tried but it does not seem to work. Any suggestions?
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?