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.

Nested IF with OR

Topic Labels: Formulas
Solved
Jump to Solution
1655 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastien_LEBLA
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone, I’m trying to set a field value based on a formula :

IF(
	OR(
		{Commandes} = BLANK(), 
		{Date_heure_RDV} = BLANK()), 
		"", CONCATENATE({Commandes} , " - ", DATETIME_FORMAT(Date_heure_RDV, 'M/DD/YYYY H:mm')),
IF(
	OR(
		{SILGAN BOL} = BLANK(), 
		{Date_heure_RDV} = BLANK()), 
		"", CONCATENATE({SILGAN BOL} , " - ", DATETIME_FORMAT(Date_heure_RDV, 'M/DD/YYYY H:mm'))   
)   
)

But when saving the formula… it just keep the first part. Is it possible to do this kind of nesting?

Thanks for your help

1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

Hey @Sebastien_LEBLANC!

Here’s my version of your formula:

IF(
    AND(
        {Date_heure_RDV},
        OR(
            {Commandes},
            {SILGAN BOL}
        )
    ),
    IF(
        AND(
            {Commandes},
            {SILGAN BOL}
        ),
        {Commandes} & " - " &
        DATETIME_FORMAT(
            {Date_heure_RDV},
            'M/DD/YYYY H:mm'
        )
        & '\n' &
        {SILGAN BOL} & " - " & 
        DATETIME_FORMAT(
            {Date_heure_RDV},
            'M/DD/YYYY H:mm'
        ),
        IF(
            {Commandes},
            {Commandes} & " - " &
            DATETIME_FORMAT(
                {Date_heure_RDV},
                'M/DD/YYYY H:mm'
            ),
            IF(
                {SILGAN BOL},
                {SILGAN BOL} & " - " &
                DATETIME_FORMAT(
                    {Date_heure_RDV},
                    'M/DD/YYYY H:mm'
                )
            )
        )
    )
)

This formula produces the following results:

image


Let me know if I’m misunderstanding something about the formula, or if you want to tweak something about it’s behavior.

See Solution in Thread

3 Replies 3
Marielle_Gueis1
6 - Interface Innovator
6 - Interface Innovator

Hi Sebastien,

Yes, it’s possible to nest, but a bit differently.
You can write the formula like this: IF(CONDITION1,OPTION1,IF(CONDITION2,OPTION2,OPTION3))

Maybe in javascript it makes more sense…
if (CONDITION1) { OPTION1 } else if (CONDITION2) { OPTION2 } else { OPTION 3 }
With this nested technique you only have 3 options. In your case you have twice “” (or Blank()) as option, so you could set “” as option 3 (in my shema), change your conditions a bit around and it should work.

Hope this helps!

Ben_Young1
11 - Venus
11 - Venus

Hey @Sebastien_LEBLANC!

Here’s my version of your formula:

IF(
    AND(
        {Date_heure_RDV},
        OR(
            {Commandes},
            {SILGAN BOL}
        )
    ),
    IF(
        AND(
            {Commandes},
            {SILGAN BOL}
        ),
        {Commandes} & " - " &
        DATETIME_FORMAT(
            {Date_heure_RDV},
            'M/DD/YYYY H:mm'
        )
        & '\n' &
        {SILGAN BOL} & " - " & 
        DATETIME_FORMAT(
            {Date_heure_RDV},
            'M/DD/YYYY H:mm'
        ),
        IF(
            {Commandes},
            {Commandes} & " - " &
            DATETIME_FORMAT(
                {Date_heure_RDV},
                'M/DD/YYYY H:mm'
            ),
            IF(
                {SILGAN BOL},
                {SILGAN BOL} & " - " &
                DATETIME_FORMAT(
                    {Date_heure_RDV},
                    'M/DD/YYYY H:mm'
                )
            )
        )
    )
)

This formula produces the following results:

image


Let me know if I’m misunderstanding something about the formula, or if you want to tweak something about it’s behavior.

@Ben.Young : You have indeed gave me the right solution… but I’m not sure I can grasp how you came to it. Anyway thanks a lot, I’ll look more into it so I could “reboot” my logic and old programmer mindset… I’ve done this for almost 20 years… but it’s been almost 10 years since I left the trade… I’m rust :thinking:

@Marielle_Gueissaz1 : Thanks for your input, I’ll “mix it” with Ben.Young solution and try to better understand why I couldn’t came with a working solution all by my self.