Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula for percent progress marking tasks as Complete

Solved
Jump to Solution
1529 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mica_Fisher
4 - Data Explorer
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?

Screen Shot 2021-10-18 at 5.45.03 PM

Thanks!
Mica

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
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"))

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
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"))

Amazing, thank you!!!