combining formulas is not working


this results in 51 records found: =COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row))

this results in 78 records found: =COUNTIFS({Campaigns Range 1}, "Not Started")

this says #incorrect argument set: =COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started")

how come?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!