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.

Find more posts tagged with

Countif

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.