Help: Formula Creation Request Please


Can someone help me by typing out what I hope is a simple formula? End result, when I update my "Status" column, I want it to enter the following amounts in my "% complete" column. FYI, Status is a drop down single choice column type. I will be so appreciative! I just don't time to figure it out by trial & error. Example below:

Pending PO Creation - 10%

Pending Shipment - 25%

Partially Received - 50%

Received Site - 100%


Best Answers

  • Rodolfo Garcia
    Rodolfo Garcia ✭✭✭✭
    Answer ✓

    Hello Collin

    1. Status Column in dropdown with your status
    2. % Complete use the format in your tool bars to set the format to percentage.
    3. Use nested IF Functions, using decimals for each status

    I hope it helps


    Rodolfo Garcia

  • Collin Ice
    Collin Ice ✭✭
    Answer ✓

    Thank you very much and I'm in business now. How exciting!! It worked this time and even better, the logic behind creating it makes sense now as well. It would be incredible if Smartsheet would make these (seemingly) simple tasks easier w/o the requirement for formulas. We have conditional formatting and to me, this is very similar. Thank you Rodolfo!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!