Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

IF Formulas Help

Topic Labels: Formulas
Solved
Jump to Solution
1075 2
cancel
Showing results for 
Search instead for 
Did you mean: 
I-Rogers
4 - Data Explorer
4 - Data Explorer

Hello. 

I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.

e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).

The bit I'm struggling with is doing this with lots of IF formulas in the same formula field. (I need about 47 different dates each returning their own specific text. 

Is this the easiest way to do this or am I missing a trick somewhere? 

Thanks in advance.

 

1 Solution

Accepted Solutions
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @I-Rogers!

Rather than using the IF() formula, you might want to check the SWITCH() formula. It will make for a way cleaner logic!

Mike, Consultant @ Automatic Nation

See Solution in Thread

2 Replies 2
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @I-Rogers!

Rather than using the IF() formula, you might want to check the SWITCH() formula. It will make for a way cleaner logic!

Mike, Consultant @ Automatic Nation

Hi Mike

Using the switch formula was much better and quicker. Cheers for the advice!