Creating a Forumla

Hello,

I am needing help with a formula.

I have two sheets, one is a sheet where all status's are, the other is where I want the data to live.

Is there a way to pull all items with the Accreditation Program and the Complete Status / the total number of items with Accreditation Program to create a % in that cell? I have it in the sheet summary, but I need this in the overview sheet.

Thank you

Find more posts tagged with

FAQ

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

Generally speaking a "same sheet" formula can be adjusted to a "different sheet" formula by updating each range to be a {Cross Sheet Reference}.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

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.