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!!
Comments
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives