Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

CountIF a cell word starts with

Options

I wanted to countif number on below example. it should bring the count 3.

Example :

Cell-2 - "Fail - Item not available'"

Cell-2 - "Fail - item out of stoke"

Cell-3 - "Fail  - routed to wrong one"

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    I think what you are asking for is to check for the "Fail" at the beginning of the text string.

    If so, this

    =COUNTIF(Status1:Status10, LEFT(@cell, 4) = "Fail")

    would count the first 10 rows of the [Status] column.

    This would count the whole [Status] column

    =COUNTIF(Status:Status, LEFT(@cell, 4) = "Fail")

    I hope this helps.

    Craig

This discussion has been closed.