Smartsheet percentage

AnyaEdgell

I'm looking to add a percentage column in my Smartsheet but every time I do it gives me the opposite information. An example is-

I would like it to say 0% since there are only 2 samples and both had issues.

Ray Lindstrom

Hi @AnyaEdgell,

Try this:

=([Total Samples]@row - [Total Issues]@row) / [Total Samples]@row

This subtracts issues from samples giving you the total non-issues, and then divides by the total samples resulting in the Quality %.

Hope this works and helps!

BRgds,

-Ray