I am trying to create a data quality score on the Contact object for the fields listed in the chart below. I am not quite sure how to calculate the weight. I have started the formula but I am not getting the correct "Actual Value".
 

IF( 
OR( 
ISBLANK(Phone), 
OR( 
CONTAINS(Phone, '000-0000') , 
CONTAINS(Phone, '111-1111') , 
CONTAINS(Phone, '222-2222') , 
CONTAINS(Phone, '333-3333') , 
CONTAINS(Phone, '444-4444') , 
CONTAINS(Phone, '555-5555') , 
CONTAINS(Phone, '666-6666') , 
CONTAINS(Phone, '777-7777') , 
CONTAINS(Phone, '888-8888') , 
CONTAINS(Phone, '123-4567') , 
CONTAINS(Phone, '456-7890')
) 
), 0, 1 
) 

+ 
IF( ISBLANK( MailingStreet ), 0, 1)+ 
IF( ISBLANK( MailingCity ), 0, 1)+ 
IF( ISBLANK( MailingState ), 0, 1)+ 
IF( ISBLANK( MailingCountry ), 0, 1)+ 
IF( ISBLANK( MailingPostalCode ), 0, 1) +
IF( ISBLANK(FirstName ) ,0,1) + 
IF( ISBLANK( LastName ) , 0, 1)+ 
IF( ISBLANK( Email ) , 0, 1)
/9

MAX SCORE: 5
MIN SCORE: 0

Thanks in advance! 


 

Hello,

I'm trying to set up a simple formula for my org that will autopopulate the case complete time when it is switched into a completed or closed status, otherwise it will put N/A in the field.  If the case is switched from completed to closed, I don't want it to update again, but if it's switched from any other value, to completed or closed, I want it to overwrite the 'N/A' and put in the closed/completed time.  

This is what I have so far, (I could be way off...) but the formula editor is giving me an error, would anyone be willing to take a look at it and let me know what I did wrong?  Thank you! 

If (AND((ISPICKVAL(Status = "Complete")||(ISPICKVAL(Status = "Closed"), ISBLANK(Complete_Date_Time) || (Complete_Date_Time = "N/A"), NOW(),
 BLANKVALUE(Complete_Date_Time, "N/A"))

 

I am trying to create a data quality score on the Contact object for the fields listed in the chart below. I am not quite sure how to calculate the weight. I have started the formula but I am not getting the correct "Actual Value".
 

IF( 
OR( 
ISBLANK(Phone), 
OR( 
CONTAINS(Phone, '000-0000') , 
CONTAINS(Phone, '111-1111') , 
CONTAINS(Phone, '222-2222') , 
CONTAINS(Phone, '333-3333') , 
CONTAINS(Phone, '444-4444') , 
CONTAINS(Phone, '555-5555') , 
CONTAINS(Phone, '666-6666') , 
CONTAINS(Phone, '777-7777') , 
CONTAINS(Phone, '888-8888') , 
CONTAINS(Phone, '123-4567') , 
CONTAINS(Phone, '456-7890')
) 
), 0, 1 
) 

+ 
IF( ISBLANK( MailingStreet ), 0, 1)+ 
IF( ISBLANK( MailingCity ), 0, 1)+ 
IF( ISBLANK( MailingState ), 0, 1)+ 
IF( ISBLANK( MailingCountry ), 0, 1)+ 
IF( ISBLANK( MailingPostalCode ), 0, 1) +
IF( ISBLANK(FirstName ) ,0,1) + 
IF( ISBLANK( LastName ) , 0, 1)+ 
IF( ISBLANK( Email ) , 0, 1)
/9

MAX SCORE: 5
MIN SCORE: 0

Thanks in advance! 


 

The report shows the different dimensions. But what we would really like to know is:
 Here is an example of a report we would like to snapshot at the end of every month.

A) How many requests were opened each month
B) How many requests were closed each month
C) How many requests were still open at month end (Total opened – total closed)
 
These metrics would be useful for each dimension, I.e. Priority, department, service, category, staff, etc.