Count if columns is not empty and the range is within the date range

John Paul Jose
edited 08/13/21 in Formulas and Functions

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))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!