Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Calculating Percentage

Hello,

I am still new to Smartsheet and struggling with formulas. Grateful id someone could help me with a formula for calculating the percentage of C-Section in column 3 below.



Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    Hi @Vinton Douglas 

    Hope you are fine, please try the following formula and convert it to column format formula:

    =IFERROR([Total C-Section]@row / [Total Deliveries]@row, "") 
    

    the following screenshot shows the result:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions