Count If Question

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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!