COUNTIF with HAS or COUNTM for Report

Daniel Martinez
edited 04/21/23 in Formulas and Functions

I'm making modifications to the marketing request template set. There is a report that ties back to the intake form. The intake report overtime adds a count of 1 to the assignee for each project completed by the assignee for each month. 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. I have tried adding HAS but I may be using it incorrectly. Would I use the COUNTM function instead? Any ideas on how to fix the formula? Here is the code I am using:

=IF(COUNTIFS({IntakeStatus}, $Status@row, {IntakeAssignedTo}, $[Primary Column]@row, {IntakeCompleteMonth}, Jan$1) = 0, 0, COUNTIFS({IntakeStatus}, $Status@row, {IntakeAssignedTo}, $[Primary Column]@row, {IntakeCompleteMonth}, Jan$1))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!