-
What is a formula to capture % Complete when the "Status" changes?
Example: When I change the Status column dropdown option to "Complete" how do I write a formula to automatically change the percent complete? I.E. Status is "Not Started" = Percent Complete is "0%" Status is "In Progress = Percent Complete is "50%" Status is Complete = Percent Complete is "100%"
-
Formula issue
I am using the following formula and getting an #UNPARSEABLE message. I have 3 field conditions that I want to check and set the box to "B" otherwise "S". I Task complete is a checkbox. =IF(AND([Status] = "Closed", [Change Type] = "BOM Cleanup", [Task Completed] = 1), B, S)
-
Need help combining these 2 IF statements
I can get both of these to work separately, but when I try combining them, using IF(OR or IF(AND or even just another IF(, the "Yellow" part won't work. Suggestions, please? =IF([Milestone Due Date]@row > ([Today Helper]@row + 30), "Green", IF([Milestone Due Date]@row > ([Today Helper]@row + 7), "Yellow", "Red"))…
