Notification when on a character (like a comma) is added to a cell

Our teams are managing portfolios of projects, often associated to multiple Opportunity ID's (tagged from Salesforce) in a unique field. The Opportunities are sometimes combined in a free text field and separated by commas.

I'd like to be notified when this cell changes and includes a comma.

Is this possible?

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @Dave H

    Glad we got it working!

    Here's the formula for everyone else.

    =IF(CONTAINS(",", [Created Projects]@row), 1)

    I'd recommend changing the column to a checkbox type and then use that to trigger the Alert.

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.