Sign in to join the conversation:
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.
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
Hi There, try this one:
=SUMIFS([cost column title]:[cost column title], [RYG column Title]:[RYG column title], "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.
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
