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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!