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

Options

#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.

Thanks

Heather

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!