Please share the Formula to Capture Creation Date for Rows in smartsheet.
myself and my teammates are am using two separate sheet with data on each every week. I want a formula to enter that tells me the date of the last entry . How can I do this?
Best Answer
-
Step 1 - Record the date of each entry
Option 1 - Use an automation
Use the Automations option at the top of your sheet.
Trigger is when rows are added.
Action is record a date - just select the column to put the date in.
Option 2 - Use the system generated created date column
Add a column to your sheet.
Select the column type - created date.
Save the sheet.
Step 2 - Formula to find the latest date in the sheet
This formula would give you the latest date in the column "Created" in the current sheet.
=MAX(Created:Created)
Do you want to find the latest date in both sheets?
Answers
-
Step 1 - Record the date of each entry
Option 1 - Use an automation
Use the Automations option at the top of your sheet.
Trigger is when rows are added.
Action is record a date - just select the column to put the date in.
Option 2 - Use the system generated created date column
Add a column to your sheet.
Select the column type - created date.
Save the sheet.
Step 2 - Formula to find the latest date in the sheet
This formula would give you the latest date in the column "Created" in the current sheet.
=MAX(Created:Created)
Do you want to find the latest date in both sheets?
-
Yes, I want to find the latest date in both sheets.
-
If you specify both columns within the same MAX formula you will find the latest date no matter which sheet it is on. You will need to use cross sheet references, for at least one column.
The formula will look something like this:
=MAX({date column on sheet 1},{date column on sheet 2})
-
@KPH your option 2 is not a possible solution. Users cannot choose "Created Date" as a column type as it is System-defined and the column is created for you automatically.
-
Hi @bkw1962
As a smartsheet user, you can choose "Created Date" as a column type. It is one of the last options in the list.
This system column will be automatically populated with the date and time the row is added and can be very useful.
For Bella, if she wants to know when a row is added to a sheet, adding the column with the type "Created date" will add a column that is automatically populated with data each time a row is added. She can then use this column in her formula.
-
Only partially correct. You cannot create a column with the Created Date type if one already exists in your sheet.
