New formula field based on 6 fields --> just the lowest should be shown with a dedicated word

How about this?

the lowest value:

the second lowest value:

 This is a funny formula

Hm? I guess I was mistaken.
Where is the dedicated word input?

Hmm, I think OP wants to show "traditional" with the lowest value, so maybe:

I can't think of an easy way to get the second lowest number though

Hey everyone,

so your approach @TheTimeSavingCo looks pretty good, but the problem is every field has a dedicated word which should appear if this field is the lowest.
for example:
Field 1= "Time" Field 2= "Day" Field 3= "break" .... Field 6= "traditional" and so on.
Is there any chance to tackle this?

I see that
Then how about this

Add a formula field named "MIN" and  formula:

Then, put in a word for each field

SWITCH function would result in an error.

If the formula for MIN is this, you get the second lowest value.

@Sho   Hmm, I think you might have accidentally pasted a different set of code in your message?  I tried the code to get the second lowest value but it did not output the expected value

I think I understand what you are doing though, and think that your original code may have looked like this:

This seems to output the expected value

I would not have thought of this method without your example code, thank you!

@TheTimeSavingCo 

Thanks for pointing this out.

It appears that a mistake was made when changing from the test code to the explanatory code.
It should now work!

Oooh, that's really nice and is even cleaner than what I thought you were doing!