Nested If Formula
I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do:
=IF([% Complete]1=0,"Not started"
=IF([% Complete]1>=0 and <=1, "On track"
=IF([%Complete)]1<=1 and Due Date is past, "Missed"</p><p> </p><p>Additionally, I would like to create a status column that shows the quarter, half, three-quarter, and full progress bars, where 1-25 has no bar, 26-50 has quarter, 51-75 has half, 76-99 has three quarter, and 100 has full. In tandem, I would like there would be a yellow status bubble for projects that are not started, green for on track, blue for complete, and red for not complete by due date (missed), all that are filled in automatically based on the nested if statements.</p><p> </p><p>Thank you in advance!</p><p><img src=https://us.v-cdn.net/6031209/uploads/drupal_attachment/files/24/d4/24d4fa88f84a20df43220d0f885e3163.PNG alt="Nested IF Problem.PNG">
Help Article Resources
Check out the Formula Handbook template!