IF Expression on a Drop-Down and Date Field

Question

I am trying to create a calculated field in an Issue Custom Form to auto-populate a date for users.

I am able to code the date using the 'ADDWEEKDAYS()' expression based on a custom date field used earlier in the form but I would like to add a certain complexity based on an another selection made in a drop-down custom field with three options 'BAU, Existing or New'.

Each of the three drop-down options would result in the generation of a different date based on the date field earlier in the form.

Does anyone know how I could use the 'IF' expression to code the three different possibilities and for the field to have the capacity to generate three different dates when taking the date field and the drop-down in conjunction?

_Manish_Singh · Accepted Answer

Hello @thomasne2, I'll make few assumptions here as the instructions are not clear.

Let’s assume:

DE:Date is the custom date field.
DE:IssueType is the drop-down field with values: 'BAU', 'Existing', and 'New'.

And the expected output is:

If IssueType = 'BAU', add 2 weekdays.
If IssueType = 'Existing', add 5 weekdays.
If IssueType = 'New', add 10 weekdays.

Then,

IF({DE:IssueType} = "BAU", ADDWEEKDAYS({DE:Date}, 2),
   IF({DE:IssueType} = "Existing", ADDWEEKDAYS({DE:Date}, 5),
      IF({DE:IssueType} = "New", ADDWEEKDAYS({DE:Date}, 10), "")))

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded