Need to count how many staff submitted form in last 7 days

=COUNTIFS({Staff name}, ="Kyle Black",({Date Completed}, AND(@cell <= TODAY(), @cell > TODAY(-7))))

or

=COUNTIFS(Staff name:Staff name,"Kyle Black", [Date Completed]:[Date Completed], and(@cell >= TODAY(-7),@cell <=Today()))

One of these i got from customer service and the other i found on a post here. I don't know if i am typing something wrong or what the issue is

Both send back #unparseable

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!