Formula Help

edited 12/09/19 in Smartsheet Basics

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:


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!!