# Formula for percent progress marking tasks as Complete

Solved
1088 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi everyone,

I’m looking to create a Field where I can mark tasks as either “Complete”, “In progress”, or “Not started” based on the Percent Complete I have manually entered in another field.

I’m using this formula, and it’s working for everything except Complete:
IF({Progress} = 100, “Complete”, IF({Progress} = 0,“Not started”, “In process”))

I’m also including a screenshot. What am I doing wrong?

Thanks!
Mica

1 Solution

Accepted Solutions
16 - Uranus

Percent fields are stored as decimal values. So 100% isn’t `100` its `1.0`. Therefore your formula should be:

``````SWITCH(
{Progress},
1, "Complete",
0, "Not started",
"In process"
)
``````

or the following if you want to stick with nested IF()s

``````IF({Progress} = 1, "Complete",
IF({Progress} = 0, "Not started", "In process"))
``````
2 Replies 2
16 - Uranus

Percent fields are stored as decimal values. So 100% isn’t `100` its `1.0`. Therefore your formula should be:

``````SWITCH(
{Progress},
1, "Complete",
0, "Not started",
"In process"
)
``````

or the following if you want to stick with nested IF()s

``````IF({Progress} = 1, "Complete",
IF({Progress} = 0, "Not started", "In process"))
``````
4 - Data Explorer

Amazing, thank you!!!