I have an account report with 3 custom date fields, all pulled from the account object. I need to populate a column in the report, based on if any of these fields are populated. If one of these fields is populated, I want the formula field to say CONTRACT, if none of these fields are populated I want the formula fields to say NONE.
I have tried with a few different variations but can't get it.
This is one option I have tried:
IF(ISBLANK(
Account.Contract1_End_Date__c,
IF(ISBLANK(
Account.Contract2_End_Date__c ,
IF(ISBLANK(
Account.Contract3_End_Date__c,
"NONE","CONTRACT"))))))
The error I get is:
Error when encoding row-level formula: Incorrect number of parameters for function 'ISBLANK()'. Expected 1, received 3
What have I done wrong?
Thanks very much!
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Sara,
Try this:
IF(AND(ISBLANK(Account.Contract1_End_Date__c),ISBLANK(Account.Contract2_End_Date__c), ISBLANK(Account.Contract3_End_Date__c)),
"NONE","CONTRACT")
