I have Formula field called "Active" with output type as Checkbox on Contracts object.
There is checkbox field on Account object and the field name "Credit Hold". This credit hold field is used to control the contract i.e, when a credit hold is checked (set to TRUE) on an account, all its related Contract records should turn inactive. Even though the End date of the contract is greater than today, we still want to make the contract inactive (we are changing the end date though).
So I setup a formula on the "Active" Field in such a way that if someone checks the credit hold checkbox on an account record, all its related Contracts will turn inactive.
In the same way, When i un-check the credit hold checkbox on the account record it should turn all the inactive contracts to active if the end date is greated than today. This part of the logic is not working with my current formula.
This is the formula i have on the Active field now:
IF(ISNULL(Project_Account__c), End_Date__c > TODAY(), End_Date__c > TODAY() && NOT(Project_Account__r.Credit_Hold__c))
What other condition do i have to add to make the formula work in both ways?