Conditional Formatting from Dropdown Menu | Excel forum

Hello everyone,

I have a question please about how I would go about solving this problem.

I'm trying to work out how to update a cell (as a percentage) from the data from another sheet.

(It should be mentioned here that I'm trying to do this in Smartsheets - but it looks to me like the syntax is pretty much the same as Excel)

I am a video editor and my managers need to know 3 states of a module (which is comprised of 11 topics).

1. Not Started
2. In Progress
3. Complete

For me and my colleagues, we need a granular level view of the progress states of each Topic and the three options are displayed in a dropdown menu.

What I'm trying to achieve is some form of conditional logic that returns a specified value when any of the following three states are selected.
For example, if "Not Started" is chosen from the menu, then we get a 0 value.
If "In Progress" is chosen we get something like 0.5
If "Complete" is chosen we get 1.

So from my view, I can see all 11 topics and they will have various statuses.
For my managers (who don't need to concern themselves with the statuses of individual Topics, just the status of the module as a whole), how would they go about constructing a formula that would allow for these various statuses and various corresponding values?
I hope that makes sense. I can take screen shots if needed.
Thanks in advance for your help!

Cheers, Dan