# Grace’s Profile

points
183

Hi everyone,

I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image).

The 2 sections are called Food and Non-Food.

The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other

Anyone here used the 6-state Pain Scale in their sheets/dashboards? We plan on using this for our customer satisfaction survey and I want to know how you guys came up with the formula. If there's an article available around this might be helpful too.

Best,

Hi all, please need your advice for the correct formula for getting the count of projects that are active within a specific month? We would like to track the number of projects that are still active for 2018.

I'm trying the formula below but I'm getting an #INCORRECT ARGUMENT error.

Hi all,

So I was able to get help around here on how I could turn amounts in thousands and millions to just K and M instead of displaying lots of zeros. Now I would like to add a formula in to just round it up with just 2 decimal places and to shorten billions too. Can someone help please?

Here's my

Hi,

Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have?

I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so because I need to create it in the report builder first so I could

Hi,

So I've been working on a formula but couldn't get it right. I wanted to count the number of my projects that are Active (on-time) and Active (delayed).

I get the on-time count correctly but for the delayed ones I always get a plus 1 in the results. Here's the formula I use (btw the stages

Hi,

Please need your help on how I can calculate my monthly savings on completed projects. I am currently using the below formula but couldn't get it right.

=SUMIFS([Negotiated/Potential Savings]:[Negotiated/Potential Savings], [Actual End Date]:[Actual End Date], <=[Summary Info 3]41,

Hi all,

I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula?

Here's the formula I used:

=COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender",

Hi,