Can I use a COUNTIFS formula based on the date a cell was populated?
Can I use a COUNTIFS formula based on the date I added a value to a cell? The information within the cell will not be a date.
I have a Smartsheet with a list of project ideas. Once it's added to our project management tool, it gets a number (ex: 123456). I have a column for "Project Number". I would like to add a line to the sheet summary that says "this month, we added ___ project's to our project management tool".
Is it possible to pick up the date that something was entered into the cell, or do I need to have 2 columns: one for "Project Number" and one for "Date Added to Project Management Tool"? (So then I would do a countif for the date column related to my today month column.
Help Article Resources
Check out the Formula Handbook template!