IF Formula Help
I would like to implement the following automation process of "% Complete" -> "Status".
The approach would be:
- IF: % Complete: 0% -> "Not Started"
- IF: % Complete: 0% ≤x≤ 100% -> "In Progress"
- IF: % Complete: 100% -> "Completed"
My current IF formula does not display and consider the last 2 conditions, I honestly do not know why.
Could anybody help me on this? :)
Many thanks in advance!!!
Help Article Resources
Check out the Formula Handbook template!