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.

Nested IF Statement

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

Hello,

I have created a check Request form in my system.  For some of our transactions we will deal with multiple transactions but I only want to have one button.  I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to create a nested if Statement (or open to other options) to fill the check Request field with the newest fee.  For example If Fee 5 is empty but Fee 4 is not then I want Fee 4 populated in the field.  If Fee 5, 4, and 3 are empty then I want Fee 2 to populate in the field.  And so on.  Appreciate any direction.

 

So far I created a nested if Statement but it only works for the first field then no longer works.

1 Solution

Accepted Solutions
ibayub
6 - Interface Innovator
6 - Interface Innovator

will it always be in that order? if so you could try the below. alternatively for something more robust you could use a script to get the non empty fee if only 1 will be populated

 

IF(

    {Fee5}, {Fee5},

    IF(

        {Fee4}, {Fee4},

        IF(

            {Fee3}, {Fee3},

            IF(

                {Fee2}, {Fee2},

                IF(

                    {Fee1}, {Fee1}

                )

            )

        )

    )

)

ibayub_0-1736794616610.png

See Solution in Thread

3 Replies 3
ibayub
6 - Interface Innovator
6 - Interface Innovator

will it always be in that order? if so you could try the below. alternatively for something more robust you could use a script to get the non empty fee if only 1 will be populated

 

IF(

    {Fee5}, {Fee5},

    IF(

        {Fee4}, {Fee4},

        IF(

            {Fee3}, {Fee3},

            IF(

                {Fee2}, {Fee2},

                IF(

                    {Fee1}, {Fee1}

                )

            )

        )

    )

)

ibayub_0-1736794616610.png

Zak1
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked perfect.  Thank you.  The order always stays the same so this works.

 

ibayub
6 - Interface Innovator
6 - Interface Innovator

my pleasure! 🙂