Please share the Formula to Capture Creation Date for Rows in smartsheet.
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})
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives