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.

RYG Formula...

Options
ECR
ECR ✭
edited 12/09/19 in Archived 2017 Posts

Looking for assistance. I am looking for a formula that adds the total number of individually RYG in a column that automatically populates a separate cell in a separate column. Any guidance would be appreciated. Thanks. - Erik

Tags:
· Share on FacebookShare on Twitter

Comments

  • Jason
    Jason Employee
    Options

    Hi Erik

     

    Try this formula

     

    =COUNTIF(Symbol:Symbol, ="Red") + COUNTIF(Symbol:Symbol, ="Yellow") + COUNTIF(Symbol:Symbol, ="Green")

     

    Where "Symbol" is the name of your RYG column. 

    · Share on FacebookShare on Twitter
  • Pranav
    Pranav ✭
    edited 02/09/17
    Options

    Need Help !!

     

    I need help to build the formula as follow:

     

    When I change Column B to (InProgress, Complete, or Risk) My Column A will change to (Red, Yellow, or Green).

     

    Also

     

    If there are any Red in the children, I want to show Red in the parent,

    If there are no Red but there are Yellow in the children, Show Yellow in the parent.

    If there are no Red or Yellow but there is Green in the children, Show Green in the parent.

     

    Following drop down list are under Column B.

     

    In Progress = Yellow

    Complete = Green

     

    Risk = Red

     

    Thanks in advance!!!

    · Share on FacebookShare on Twitter
  • ECR
    ECR ✭
    Options

    Thanks everyone. Worked perfectly!

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories