
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2021 02:50 PM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2021 06:04 PM
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"))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2021 06:04 PM
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"))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 19, 2021 07:46 AM
Amazing, thank you!!!
