Nested IF Contains Formula

Forum|Forum|6 years ago
June 25, 2019
3 replies
38 views

+5

Nicole_Flewelle
Participating Frequently

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

+5

W_Vann_Hall
Inspiring
Forum|Forum|6 years ago
June 25, 2019

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}.