How to reference two columns on a different sheet for a formula on another sheet using countif


Im creating a rollup page for a dashboard and need to create a formula to count 2 separate columns. Basically i want the amount of "pilot" studios that are "validated" or "not validated.

Here is what i currently have:

=COUNTIFS({Studio Network Stack Submissions Range 2}), "not validated"),{Studio Network Stack Submissions 6-5-2020 Range 1}, "Pilot"))

I keep getting a #UNPARSEABLE error

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!