Skip to main content

Hello,


First post and couldn’t find the answer. I’m trying to create a nested IF.


Field A, single select as choice 1, 2, or 3.

Field B, is a Date

Field C, is a Date

Field D, is a Date


I’d like to the formula to check the value of Field A.

If it’s 1, return date from B,

If it’s 2, return date from C

If it’s 3, return date from D


Thanks!

You’ll want to use a formula like…


SWITCH({Field A}, “1”, {Field B}, “2”, {Field C}, “3”, {Field D})

You’ll also probably want to use DATETIME_FORMAT() to get your dates formatted the way you want. 🙂

You’ll want to use a formula like…


SWITCH({Field A}, “1”, {Field B}, “2”, {Field C}, “3”, {Field D})

You’ll also probably want to use DATETIME_FORMAT() to get your dates formatted the way you want. 🙂


Thanks. I keep getting errors. Here’s the exact fields.


Field is called Renewal Date. Formula below

Based off the formula, I want it to populate the date from the correct field.

“Renewal Type” is a single select. Options are P&C, Benefits, LFS.


So if P&C is selected, use the date in the “P&C RD” field.


SWITCH({Renewal Type}, “P&C”, {P&C RD}, “Benefits”, {B RD}, “LFS”, {LFS RD})


What am I missing?


Thanks!!

Thanks. I keep getting errors. Here’s the exact fields.


Field is called Renewal Date. Formula below

Based off the formula, I want it to populate the date from the correct field.

“Renewal Type” is a single select. Options are P&C, Benefits, LFS.


So if P&C is selected, use the date in the “P&C RD” field.


SWITCH({Renewal Type}, “P&C”, {P&C RD}, “Benefits”, {B RD}, “LFS”, {LFS RD})


What am I missing?


Thanks!!


Your formatting looks correct, so perhaps you are just running into an issue with smart quotes being used in your formula, instead of dumb quotes – this can happen if you copy/pasted a formula out of the forums that has smart quotes in it (like @AlliAlosa’s does).


To remedy that, try clearing your formula entirely, and typing it in by hand into the formula field editor.

Thanks. I keep getting errors. Here’s the exact fields.


Field is called Renewal Date. Formula below

Based off the formula, I want it to populate the date from the correct field.

“Renewal Type” is a single select. Options are P&C, Benefits, LFS.


So if P&C is selected, use the date in the “P&C RD” field.


SWITCH({Renewal Type}, “P&C”, {P&C RD}, “Benefits”, {B RD}, “LFS”, {LFS RD})


What am I missing?


Thanks!!


It could be the quotes as @Jeremy_Oglesby mentioned, but I am all of a sudden (as in within the last hour or so) returning errors on ALL of my fields that incorporate the SWITCH() function… I just started a new thread on this and am about to contact support!

Reply


Terms & Conditions