Skip to main content
SharePoint

Return to Question

added 4 characters in body
Source Link
Eric Alexander
Eric Alexander
  • 43.4k
  • 10
  • 55
  • 93

Here is my current formula that works.

="=[Current Date],"green","red")),IF([Project Close P]>=[Project Close A],"green","red"))&";'>•"

="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Project Close A]="",IF(Program="CAPITAL",IF([Project Close P]>=[Current Date],"green","red")),IF([Project Close P]>=[Project Close A],"green","red"))&";'>•</DIV>"

I now need to add an additional IF statement that states if Project Cloase P is blank turn yellow. When I add If([Project Close P]="", "yellow" to the front of the above it doesn't work. How do I fix this?

Here is my current formula that works.

="=[Current Date],"green","red")),IF([Project Close P]>=[Project Close A],"green","red"))&";'>•"

I now need to add an additional IF statement that states if Project Cloase P is blank turn yellow. When I add If([Project Close P]="", "yellow" to the front of the above it doesn't work. How do I fix this?

Here is my current formula that works.

="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Project Close A]="",IF(Program="CAPITAL",IF([Project Close P]>=[Current Date],"green","red")),IF([Project Close P]>=[Project Close A],"green","red"))&";'>•</DIV>"

I now need to add an additional IF statement that states if Project Cloase P is blank turn yellow. When I add If([Project Close P]="", "yellow" to the front of the above it doesn't work. How do I fix this?

Source Link
Trisha
Trisha
  • 53
  • 1
  • 1
  • 3

Calculated Column with Nested IF statments

Here is my current formula that works.

="=[Current Date],"green","red")),IF([Project Close P]>=[Project Close A],"green","red"))&";'>•"

I now need to add an additional IF statement that states if Project Cloase P is blank turn yellow. When I add If([Project Close P]="", "yellow" to the front of the above it doesn't work. How do I fix this?