Count the number of "No" in the entire row across multiple columns
I have 45 questions in a survey in Smartsheet. So, that is 45 columns of questions. All the questions are single select "Yes/No/NA". One row of data equals one survey.
Is there a way to count the number of "No"s in one row and put it in the "Failures" column? I am trying to get a count of the items that failed for that row so that it can be included in a workflow automation email to let the person know how many items need to addressed.
Help Article Resources
Check out the Formula Handbook template!