Smartsheet percentage

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
    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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!