We are trying to count how many applicants applied in the last 7 days for Delta client

The formula we used is :

=COUNTIFS([Avature Application]:[Avature Application], Client:Client, "Delta", @cell <= TODAY(), [Avature Application]:[Avature Application], @cell > TODAY(-7))

Once we get it for this sheet, we want to do the same for a few sheets and add them all together to know the total. we use this sheet as the start sheet but applicants move to other sheets


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!