Help needed with Count Formula
SummaryWould like to count more then one CSW Step in the same column
Can anyone help me with this formula? currently it's counting only Step "Submitted" however I would like to add another step in the count called "Recruiter Assessment".
Is it easier to count "All" the Steps then only remove the status I don't need?
Here is the current formula:
count (distinct case when "Submission CSW Status - Historical"."Historical Step Name" = 'Submitted' then "Submission General Info"."Submission Identifier" end )