Skip to main content
Solved

Formula for percent progress marking tasks as Complete

  • October 18, 2021
  • 2 replies
  • 28 views
M

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

Best answer by Kamille_Parks11

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

    Kamille_Parks11
    Forum|alt.badge.img+27

    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"))
    M
    Justin_Barrett
    M
    • Mica_Fisher
    • Author
    • New Participant
    • October 19, 2021

    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!!!

    Terms & ConditionsAccessibility statement