Working to pull data in from four sheets to a master rollup sheet and keep getting an error

#incorrect argument set

=COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXX Liquid Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXXX Product Range 2}, Primary7, {Status}, <>"Complete")

I'm using a Smartsheet template and the formula was already in the sheet, I just am adding sheets to it. Any help would be appreciated.




  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are the ranges in each formula referencing the same sheet as the other ranges in the same formula? Basically... Are these cross sheet ranges

    COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete")

    All on the same sheet as each other? Same for the remaining COUNTIFS?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!