Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1 or Q2 or Q3 has a value, or is not blank") for NeedBy Date in 8 weeks, by location.
For example, in the following table, I would get these:
Reno= 1
Elko= 1
Carson City= 1
I tried:
=COUNTIFS({QuestionnairreLocal}, [Primary Column]@row, {QuestionnaireNeedDate}, @cell <= TODAY(112), {QuestionnaireNeedDate}, @cell >= TODAY(105), (OR({QuestionnaireQ1}, <>"", {QuestionnaireQ2}, <>"", {QuestionnaireQ3}, <>"")).
However when I do this, I get #INVALID DATA TYPE.
Suggestions for if and how I can count the number of rows in my questionnaire Smartsheet that meet this criteria