SUMIF using RYG Status

Patburke ✭✭
edited 12/09/19 in Smartsheet Basics

Need help missing the boat on sumif based on status column using RYG. This is is a sales pipe line and trying to sort totals based on status.


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Pat,

    Can you share a screenshot, the sheet or column what your column names are?


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: | | P: +46 (0) - 72 - 510 99 35

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi There, try this one: 

    =SUMIFS([cost column title]:[cost column title], [RYG column Title]:[RYG column title], "Green")

    • Replace "cost column title" with the title of the cost column that you want to sum together. 
    • Replace "RYG column title" with the title of your column.
    • And place whatever color that you are wanting to check against, Red, Yellow or Green in place of "Green" 

    Hope that helps you get going. I used sumifs because its easy to add another condition in case you want to modify it to something else and works with even a single condition.