Sheet Summary Countifs on columns with formulas
Options
fwarsi
✭
I'm trying to build sheet summary metrics utilizing countifs against multiple columns but the column ranges themselves have vlookups in it.
Unless I hard code the column values so that they are static, my formulas won't work and giving the [No Match] error for my criteria.
Is there a workaround for this?
Tags:
Answers
-
Are you able to provide some screenshots for context?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!