IF(AND

 

Discussion List

• 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%" St…

  

  Answered

  Formulas

  IF(AND

  IF(

  Formulas and Functions

  74

  May 23, 2024

  1

• 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([Statu…

  

  Answered ✓

  IF(AND

  Formulas and Functions

  91

  May 16, 2024

  2

• 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]@r…

  

  Answered ✓

  IF(OR

  IF(AND

  IF(

  Formulas and Functions

  121

  May 14, 2024

  5