Count If Question

Daniel Martinez

I have modified the marketing request template set. There is a report that ties back to the intake form. The intake report adds a count of 1 to the assignee for each project assigned to the assignee. The issue I am having is, if there are multiple people assigned to the filed the count if function isn't adding a count to each assignee. Is there a formula that will add one to each assignee for projects with multiple assignees? Here is the code I am using:

=COUNTIFS({GSRStatus}, Status@row, {IntakeAssignedTo}, [Primary Column]@row)

Paul Newcome

You will need a HAS function:

=COUNTIFS({GSRStatus}, Status@row, {IntakeAssignedTo}, HAS(@cell, [Primary Column]@row))

Paul Newcome

You will need a HAS function:

=COUNTIFS({GSRStatus}, Status@row, {IntakeAssignedTo}, HAS(@cell, [Primary Column]@row))

Daniel Martinez

Thank you so much Paul! I appreciate your help greatly!

Paul Newcome

Happy to help. 👍️