Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to use the Switch formula for greater than, lesser than criteria?

Topic Labels: Formulas
Solved
Jump to Solution
3615 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Burner
7 - App Architect
7 - App Architect

Hi,

I’m trying to get familiar with the SWITCH formula by taking a shot at using it instead of a nested IF but can’t seem to figure out the following.

I have a field called “Expiry Date” (type Date) and another field called “Expired?”, which is a formula field where I’m trying to use the SWITCH formula. My goal is that the “Expired?” field formula should output “Expired” if the “Expiry Date” is lesser than TODAY(); it should output “Expires today” if the “Expiry Date” equal to TODAY(); and should output “Still Active” if the "Expiry Date is greater than TODAY().

The formula I’m using is

SWITCH({Expiry Date},<TODAY(),"Expired",=TODAY(),"Expires Today", >TODAY()"Still Active","N/A")

I’m definitely doing something wrong because I’m getting a formula error.

Can somebody please help me with this.

Thanks,
Sean

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You’ll need to use a nested IF formula, because that’s not how the SWITCH function works. The SWITCH function only allows one expression, and then you list a static set of results to choose from.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

You’ll need to use a nested IF formula, because that’s not how the SWITCH function works. The SWITCH function only allows one expression, and then you list a static set of results to choose from.

Ah, got it. Thanks, Scott. Appreciate it.