Percentage complete to feed from text option in single select dropdown

Options

I would like the % Complete to feed from a drop down list of the following options

Not Started (0%)

In Progress (50%)

Waiting for Review (90%)

Complete (100%)

I'm stuck on where to even start that one. The options are coming from a drop down column that is single select and limited to those options

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Lizzie Armstrong

    You can build this out by having each instruction identified in an IF statement. Keep in mind that percentages are decimals in formulas, so instead of 50% you would write 0.5, then format the column to be a Percent column using the toolbar at the top.

    Try this:

    =IF([Dropdown Column]@row = "Not Started", 0, IF([Dropdown Column]@row = "In Progress", 0.5, IF([Dropdown Column]@row = "Waiting for Review", 0.9, IF([Dropdown Column]@row = "Complete", 1))))


    You'll need to replace the [Dropdown Column] with your column name. Let me know if this works for you, and if it makes sense!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!