Hello -
Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula
Hello -
Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula
Hi @Ashley_B
Try using the formula
IF({Year Opt In}='yes', DATEADD(Tenure, 1, 'years'), " ")
@Harsh2 I inserted the formula and didn't get an error message (aka the formula was accepted) but it still doesn't generate a new date if the drop down is Yes. Any other thoughts?
Hi @Ashley_B
Wouldn't it be like this?
IF(
{1+ YEar Opt In}='yes',
DATEADD({Current WON Role Start Date}, 3, 'years'),
DATEADD({Current WON Role Start Date}, 2, 'years')
)
Does the "1+ Year Opt In" field have options other than Yes and No? If not, I think a Checkbox field would be more appropriate for the UI.
If you change it to a checkbox field, it will look like this.
IF(
{1+ YEar Opt In},
DATEADD({Current WON Role Start Date}, 3, 'years'),
DATEADD({Current WON Role Start Date}, 2, 'years')
)
Hi @Ashley_B
Wouldn't it be like this?
IF(
{1+ YEar Opt In}='yes',
DATEADD({Current WON Role Start Date}, 3, 'years'),
DATEADD({Current WON Role Start Date}, 2, 'years')
)
Does the "1+ Year Opt In" field have options other than Yes and No? If not, I think a Checkbox field would be more appropriate for the UI.
If you change it to a checkbox field, it will look like this.
IF(
{1+ YEar Opt In},
DATEADD({Current WON Role Start Date}, 3, 'years'),
DATEADD({Current WON Role Start Date}, 2, 'years')
)
@Sho I'd like to keep it as a yes/no option. If they decide not to opt-in, then I need to be alerted to start the roll off plan for them. So this will help me have a clear record.
I tried your formula and it generated the exact same date that I have in the 'tenure' column. If I selected 'yes', the date didn't change.
@Sho I'd like to keep it as a yes/no option. If they decide not to opt-in, then I need to be alerted to start the roll off plan for them. So this will help me have a clear record.
I tried your formula and it generated the exact same date that I have in the 'tenure' column. If I selected 'yes', the date didn't change.
Hi,
Formula expression is case-sensitive. If your single-select 'Yes' has capital letter, IF({Field}='yes'.. will be FALSE.
You should adjust the case, or do it like IF(UPPER({Field})='YES'...
Hi,
Formula expression is case-sensitive. If your single-select 'Yes' has capital letter, IF({Field}='yes'.. will be FALSE.
You should adjust the case, or do it like IF(UPPER({Field})='YES'...
♀️ Thank you @Alexey_Gusev
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.