You need to sign in to do that
Don't have an account?
anil Kumar
Formula field to calculate fields completeness
Hi All,
I need to create formula field to calculate fields completeness. Please help me on this.
Name : 30%
Email: 25%
Phone: 25%
Address: 10%
DOB: 10%
Thanks,
I need to create formula field to calculate fields completeness. Please help me on this.
Name : 30%
Email: 25%
Phone: 25%
Address: 10%
DOB: 10%
Thanks,
please try following formula
Please let me know, If it's help.
All Answers
Please Try this
(If( Name , 30, 0)+ If( Email , 25, 0)+ If( Phone , 25, 0) + If( Address , 10, 0) + If( DOB, 10, 0))
Please find the below link for further reference.
https://developer.salesforce.com/forums/?id=9060G000000Xdn3QAC
I hope you find the above solution helpful. If it does, please mark it as Best Answer to help others too.
Thanks and Regards,
Sachin Arora
www.sachinsf.com
Thank you for the responce. I have tried above formula with return type of Number and Percentage. I am getting beloe syntax erroe.
Incorrect parameter type for function 'IF()'. Expected Boolean, received Text
Thanks,
please try following formula
Please let me know, If it's help.