You need to sign in to do that
Don't have an account?
Padtalluri
Formula field is returning for all record types created date + 3 working days , please help for the below formula
I have written the below formula field to add the number of working days to the created date for diffrent record types , but it is adding 3 business days to all scenarios.
IF(RecordType.DeveloperName ="Request_for_Data",CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 3),
IF(RecordType.DeveloperName ="Network_Information_Request", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 6),
IF(RecordType.DeveloperName ="Network_Analysis_Request", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),
IF(RecordType.DeveloperName ="Network_Analsysis_Adding_New_Employees_Divisions", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),
IF(RecordType.DeveloperName = "Network_Options_Due_to_Provider_Termination",
CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),null)
)
)
)
)
IF(RecordType.DeveloperName ="Request_for_Data",CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 3),
IF(RecordType.DeveloperName ="Network_Information_Request", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 6),
IF(RecordType.DeveloperName ="Network_Analysis_Request", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),
IF(RecordType.DeveloperName ="Network_Analsysis_Adding_New_Employees_Divisions", CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),
IF(RecordType.DeveloperName = "Network_Options_Due_to_Provider_Termination",
CASE(
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
3, CreatedDate + 2 + 3,
4, CreatedDate + 2 + 3,
5, CreatedDate + 2 + 3,
6, CreatedDate + 1 + 3,
CreatedDate + 8),null)
)
)
)
)