Help

Re: Nested IF Contains Formula

645 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicole_Flewelle
6 - Interface Innovator
6 - Interface Innovator

I’m trying to create a field (Bulletins) that will return one of three values, based on the presence of one of three phrases in a record’s long text field. Basically:

If Comments contains Advance Notice, then populate Bulletins field with Advance Notice
If Comments contains Time Sensitive, then populate Bulletins with Time Sensitive
If Comments contains Update, then populate Bulletins with Update

I’ve tried a couple configurations to get it to work and can’t quite get there. Any help would be much appreciated!

3 Replies 3

Try

IF(
    FIND(
        'advance notice',
        LOWER(
            {Comments}
            )
        ),
    'Advance Notice',
    IF(
        FIND(
            'time sensitive',
            LOWER(
                {Comments}
                )
            ),
        'Time Sensitive',
        IF(
            FIND(
                'update',
                LOWER(
                    {Comments}
                    )
                ),
            'Update'
            )
        )
    )

The LOWER() makes sure the match isn’t case sensitive.

You can copy-and-paste that formula, indentations and all, into the formula configuration window of {Bulletins}.

Nicole_Flewelle
6 - Interface Innovator
6 - Interface Innovator

Thank you! Worked like a charm!

Eddie_Kaeser
6 - Interface Innovator
6 - Interface Innovator

I used this too! Thanks for posting!