Is it possible to get a count in Sheet Summary with the following equation?

=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0)))

I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s)

Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my sheet and have this on the sheet summary.

Find more posts tagged with

Sheets

Formulas

Accepted answers

Lori Leighton

Thanks! There is no other way to make it happen?

All comments

Andrée Starå

Hi @Lori Leighton

I hope you're well and safe!

Unfortunately, it's not possible because you can't use the @row feature because Smartsheet doesn't know which row it should reference.

Make sense?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lori Leighton

Thanks! There is no other way to make it happen?

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.