Welcome!

Formula Help

Hi All-

I'm a recruiter attempting to report various candidate metrics to a client. One metric I wish to report includes candidate 'Dismiss/Decline' reasons. These reasons are recorded under a 'Status' column and are selected among various options in a drop-down box). So I need to create a formula that tallies the number of candidates in each 'dismiss/decline' reason.

The status column looks like this presently:

STATUS:

Candidate Declined (Relocation)

Candidate Declined (Content with current employer)

Candidate Declined (Accepted other position)

Etc., etc....

Any suggestions on a viable formula would be greatly appreciated!!

Find more posts tagged with

Comments

Shaine Greenwood

Hello,

I think you'll need to have two formulas for this. If you create a new text/number column and place a =FIND("Declined", Status1) function in there, you can then create a =COUNT([Declined Count]:[Declined Count]) formula for your total.

Andrée Starå

Hi,

You could also publish a Dashboard with relevant information and KPIs for the client.

Have a fantastic weekend!

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…