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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!