Percentage complete to feed from text option in single select dropdown

Lizzie Armstrong

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

Genevieve P.

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