Count of cells in a date range

i__heidig

Hello, - I am fairly new to Smarsheets and not very knowledgable past basic formulas.  I am trying to create a formula that  will display the count of cells whose date is from Monday through Sunday, each week.  Like how many open items were closed this week. I can't seem to figure out the criteria wording.... 

Thanks!!!!!!!!!!!!!!!

Shaine Greenwood

Hello,

I'd recommend that you try using a COUNTIFS function. For example:

=COUNTIFS([Start Date]:[Start Date], > DATE(2018, 3, 26), [Start Date]:[Start Date], < DATE(2018, 3, 30) ,[Status]:[Status], "Closed")

More information on COUNTIFS: https://help.smartsheet.com/function/countifs

DATE: https://help.smartsheet.com/function/date

 

daviserl

THANK YOU! This is the first formula I've found that works... now if I can just get it to work in a rollup sheet!!