8 Out of 10 Deployed Formula

Smartsheet Community:

I am Trying to Count The Number of Deployed Items Out of The Total Number of Installs. I am Referencing a Another Sheet.

Here is My Criteria: Status Has to Be Installed or Already Installed to Count it as Installed.

Expected Formula Results: 8 Out of 10 Deployed

Current Unsuccessful Formula:

=COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed") + "Of" + COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Deployed")

Thanks in Advance

Find more posts tagged with

Accepted answers

Paul Newcome

You could also use "is not equal to blank" to save yourself some typing in the future:

=COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Out Of " + COUNTIFS({Status}, @cell <> "") + " Deployed"

All comments

Paul Newcome

Move the very last closing parenthesis to immediately after the first "Already Installed". You closed out the OR statement but forgot to close out the COUNTIFS.

VirtixIT

https://community.smartsheet.com/discussion/comment/385367#Comment_385367

That Worked but I think My Formula is Not Arranged Correctly and Missing Something. I am Getting a Result of:

84 Out of 84 Formula Below:

=COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Out Of " + COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Deployed")

I Should Have 84 Out of 136

Here All The Statuses That Total 136: Not Installed, Install in Progress, Installed, Already Installed, Failed-Under Investigation, Investigate-Time.

84 Are Already Installed or Installed

Where Should I Include The Status The First CountIFS?

VirtixIT

https://community.smartsheet.com/discussion/comment/385398#Comment_385398

I Figured it Out which I am Sure you Already Knew The Answer LOL. See Formula Modified Formula Belwo:

=COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Out Of " + COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed", @cell = "Not Installed", @cell = "Failed-Under Investigation", @cell = "Investigate-Tixr")) + " Deployed"

Paul Newcome

You could also use "is not equal to blank" to save yourself some typing in the future:

=COUNTIFS({Status}, OR(@cell = "Installed", @cell = "Already Installed")) + " Out Of " + COUNTIFS({Status}, @cell <> "") + " Deployed"

VirtixIT

https://community.smartsheet.com/discussion/comment/385403#Comment_385403

Ok, Thanks! I Appreciate it.

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.