I am trying to create a report based on the 'Customer Installation Completed Date'plus 90 days on the Opportunity AND 'Was this a Referral?' Checkbox on the Account is True
I tried to create a formula field to populate this (90+ date of completion) using the following syntax-
IF( Was_this_a_Referral__c = TRUE, NULL, Opportunity__r.Customer_Installation_Completed_Date__c +90)
I did this so this 'Install +90 days' field is available to report on.
1)I am not sure if I am taking the correct route to report on this 2)Not sure if the formula I created is correct 3) If 1 &2 are correct then currently that new formula field is not populating any dates.