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.

Tags:

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    You need two columns and a COUNTIFS. There is a system field that records the date a row was added to the sheet. Could you use this instead of entering the date? You can find it towards the bottom of the list of column formats.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!