Skip to main content

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!

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

Thank you! Worked like a charm!

I used this too! Thanks for posting!

Reply


Terms & Conditions