Welcome!

SUMIF using RYG Status

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.

Find more posts tagged with

Comments

Andrée Starå

Hi Pat,

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

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
Burn Down chart with Work Insights
Hello, I was not able to find any example on how to set up smartsheet work insight to obtain a burn down chart. Could someone share how you've done it? The tutorial provided by smartsheet is vague and does not bear results. And, no examples on Youtube either. I saw one person asking the same question a couple years ago and…