8 Out of 10 Deployed Formula

VirtixIT

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

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"

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. 👍️