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.
