Good afternoon,
I have no idea how to describe this accurately.
Basically,
On the intake sheet, when people fill-out the form, there is a column that will list the site number of the property they are at. That column will show number designations from all three branches.
I want to use this section of a metrics sheet to count how many times a site number of a specific branch has been input into the intake sheet. I set up a third sheet, using three columns, to list each branch's site numbers under the column. The idea would be that this sheet would be a reference for the count to compare against.
And I want to do this for three branches.
Currently I have
=COUNTIF({IntakeSheet Range 1}, HAS(@cell, {SiteListSheet Range 1} ))
but it returns a 0
Any help would be appreciated,
Thank you.
