I have two custom objects Sale__c and Project__c. Both Sale__c and Project__c have different status in a picklist. Sale__c status is broken into two picklist Status__c and Status Detail__c Project has one status proect_status__c.
I am looking to create a trigger that updates the Sales status and status detail to "Net" (status) "completed" (status detail) when all related projects in a sale have a status of "completed" I only want the status and detail to change if the status is already NOT "final" or "paid in full" OR status detail NOT "invoiced"
I have tried to do this with a simple workflow rule and field update, but have not had any luck.