Created (date) format in formuals

darelcragnolin32946

When using the COUNTIFS formula and referencing the created (date) column in another sheet, what date / time format do I need to use when including a specific date as criterion?

Mike Wilday

You will need to follow Smartsheet's setup for date. 

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

 

darelcragnolin32946

Many thanks Mike. For the life of me I couldn't find this information, probably because I didn't think I needed to actually invoke the DATE function. Cheers!

Mike Wilday

You're welcome! Have a great day.