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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!