Formula that will look at how many submissions there have been by group in the last 7 days

tjeffreys

I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions there were last week for each group.

=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY()), ({JHA Tracker with Form Range 66}, @cell > TODAY(-7)), ({JHA Tracker with Form Range 4}, (CONTAINS("I&R", @cell)))

Paul Newcome

You are doing too much with the parenthesis. Try this:

=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY(), {JHA Tracker with Form Range 66}, @cell > TODAY(-7), {JHA Tracker with Form Range 4}, CONTAINS("I&R", @cell))

Paul Newcome

You are doing too much with the parenthesis. Try this:

=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY(), {JHA Tracker with Form Range 66}, @cell > TODAY(-7), {JHA Tracker with Form Range 4}, CONTAINS("I&R", @cell))

tjeffreys

It got me closer I think, gave me an Incorrect Argument error

tjeffreys

https://community.smartsheet.com/discussion/comment/468554#Comment_468554

Just refreshed and it worked. Thank you!

Paul Newcome

Happy to help. 👍️