Nested IF Contains Formula

[Nicole_Flewelle]

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!

[W_Vann_Hall]

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]

Thank you! Worked like a charm!

[Eddie_Kaeser]

I used this too! Thanks for posting!