The project criteria is to have two fields on the opportunity, electric utility and gas utility that are automatically 
filled out without user input. Utilities are based on two critera, city and state.

First I created a custome object called Utility with the fields city, state, elecric utiliy and gas utility. I took the city 
and state field and put them together to create "Utility_Service_Area__c" and did the same on the opportunity. 
On the opportunity I created a lookup field linking the Opportunity utility service area to that on the Utility custom 
object.

I then created two more fields on the opportunity (electric and gas utilities). These two fields are the reason for the whole project. The following is  an example of the electric utility field (Utility_Service_Area__r.Electric_Utility__c). I felt that this should work but it doesn't. 

Any help on solving this would be greatly appreciated!

If either Statement 1 or Statement 2 is true then red, else green

Statement 1
IF( 
AND( 
Owner.LastName <> "Partners", RecordType.DeveloperName = "Phase 4" ),

OR

Statement 2
IF( 
AND( 
NOT(ISBLANK(Under_Current_Contract_Until__c)), Under_Current_Contract_Until__c>=TODAY(), 
Owner.LastName <> "Partners" ),

IMAGE("/img/samples/color_red.gif", "red", 30, 30),
IMAGE("/img/samples/color_green.gif", "green", 30, 30)

Two different conditions in one formula field.

IF( 
AND( 
NOT( 
ISBLANK(Under_Current_Contract_Until__c)), 
Under_Current_Contract_Until__c >=TODAY(), 
Owner.LastName <> "Partners"), 
IMAGE("/img/samples/color_red.gif", "red", 30, 30), 
IMAGE("/img/samples/color_green.gif", "green", 30, 30))

I need to incorporate these parameters into the formula
above. These two conditions need to always be red.

RecordType.DeveloperName = "Phase 4,
Owner.LastName <> "Partners"

In other words I need these two parameters to supersede the other conditions.
I have tried OR statements and nested IF statements without success.

Any help would be appreciated. Thanks!

Help! I am new to salesforce formulas and can't seem to get this to work.
All I am trying to do is create a "stop light" to indicate whether it is currently 
being worked so "hands off" or whether it is open for someone else to claim.

Creating a new formula field
Stop Light on Opportunity Object

IF     1 Owner = SES Partners
        2 Missing Task
        3 or Task > 7 days overdue
        4 Missing CXD 
        5 or CXD Expired
GreenIMAGE("/img/samples/light_green.gif", "Green")

IF     1 Task is in future 
        2 or Task <7 days Overdue
        3 CXD is current
        4 or(If Phase = 4
RedIMAGE("/img/samples/light_red.gif", "Red")

Where CXD = Current Contract Expiration Date

I would be eternally greatfull for anyone who could help me solve this!

Thanks!
Gary Allen
 

The project criteria is to have two fields on the opportunity, electric utility and gas utility that are automatically 
filled out without user input. Utilities are based on two critera, city and state.

First I created a custome object called Utility with the fields city, state, elecric utiliy and gas utility. I took the city 
and state field and put them together to create "Utility_Service_Area__c" and did the same on the opportunity. 
On the opportunity I created a lookup field linking the Opportunity utility service area to that on the Utility custom 
object.

I then created two more fields on the opportunity (electric and gas utilities). These two fields are the reason for the whole project. The following is  an example of the electric utility field (Utility_Service_Area__r.Electric_Utility__c). I felt that this should work but it doesn't. 

Any help on solving this would be greatly appreciated!

If either Statement 1 or Statement 2 is true then red, else green

Statement 1
IF( 
AND( 
Owner.LastName <> "Partners", RecordType.DeveloperName = "Phase 4" ),

OR

Statement 2
IF( 
AND( 
NOT(ISBLANK(Under_Current_Contract_Until__c)), Under_Current_Contract_Until__c>=TODAY(), 
Owner.LastName <> "Partners" ),

IMAGE("/img/samples/color_red.gif", "red", 30, 30),
IMAGE("/img/samples/color_green.gif", "green", 30, 30)

Two different conditions in one formula field.

IF( 
AND( 
NOT( 
ISBLANK(Under_Current_Contract_Until__c)), 
Under_Current_Contract_Until__c >=TODAY(), 
Owner.LastName <> "Partners"), 
IMAGE("/img/samples/color_red.gif", "red", 30, 30), 
IMAGE("/img/samples/color_green.gif", "green", 30, 30))

I need to incorporate these parameters into the formula
above. These two conditions need to always be red.

RecordType.DeveloperName = "Phase 4,
Owner.LastName <> "Partners"

In other words I need these two parameters to supersede the other conditions.
I have tried OR statements and nested IF statements without success.

Any help would be appreciated. Thanks!

Help! I am new to salesforce formulas and can't seem to get this to work.
All I am trying to do is create a "stop light" to indicate whether it is currently 
being worked so "hands off" or whether it is open for someone else to claim.

Creating a new formula field
Stop Light on Opportunity Object

IF     1 Owner = SES Partners
        2 Missing Task
        3 or Task > 7 days overdue
        4 Missing CXD 
        5 or CXD Expired
GreenIMAGE("/img/samples/light_green.gif", "Green")

IF     1 Task is in future 
        2 or Task <7 days Overdue
        3 CXD is current
        4 or(If Phase = 4
RedIMAGE("/img/samples/light_red.gif", "Red")

Where CXD = Current Contract Expiration Date

I would be eternally greatfull for anyone who could help me solve this!

Thanks!
Gary Allen