Count if columns is not empty and the range is within the date range
Im trying to make a formula work. My logic is to count the number of cells which the projectmanagers column is not blank and the projectmanagers row is edited in the last 7 days.
This is the formula im using but it keeps returning "#INCORRECT ARGUMENT SET"
any idea on what could I be doing wrong? Any help is appreciated. Thanks!
=COUNTIFS({project managers}, <>"", {modified}, >TODAY(7))
Answers

This is solved now. I used a different column as reference as the project managers column is 3 columns in total with gaps and causing me problems in the formula. Thanks!

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!