Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How do I write a countif nested formula?
I have looked in the forumula info and I think what I have written will do what I need but it is not working. I want to count all the times my Ward column is 1 and then my Assistance column says survey. This is my formula:
="Ward 1=" + COUNTIFS(Ward:Ward, "1", [Assistance 1]:[Assistance 1], "Survey")
The correct count right now should be 1 (as in there is one survey done for Ward 1) but it says 0.
Any thoughts? And I know I can use reports but I want the team to see a running count on the sheet.