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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives