Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting rows between two sets of dates

Alethea Carbaugh
edited 12/09/19 in Archived 2017 Posts

Hi Smartsheet Community,

I'm trying to figure out how to count a row if the date column falls between a set of dates.  Basically, I'd like to use the COUNTIF formula and count the row if the date is between 07/01/17-09/30/17.  

Any ideas on how to do this?  I'd rather not add in an additional check box, just base the formula off the date column. 

Thanks! 

Tags:

Comments

This discussion has been closed.