Could anyone help with solve this issue

I have 12 questions in a call audit smartsheet so the formula is as follows

=((COUNTIF([Question1]@row:[Question12]@row, "poor") * 0.25) + (COUNTIF([Question1]@row:[Question12]@row, "fair") * 0.5) + (COUNTIF([Question1]@row:[Question12]@row, "good") * 0.75) + COUNTIF([Question1]@row:[Question12]@row, "Excellent")) / 12

which works well but I need a line for N/A that is equal to good E.G. same value as good but so you would know if the answer to a question was good or N/A.

I do not want the person being audited to be marked up or down for a N/A answer hence being equal to good, but I can figure it out please help

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for reference?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.