Vlookup from Created Date column
Best Answer
-
@Clayton Ferreira Smartsheet stores the Created date in UTC, even though it appears as your local time in the sheet. You can created a new column to ensure you are calculating on your local time. See my video here on how to do this:
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@Clayton Ferreira Smartsheet stores the Created date in UTC, even though it appears as your local time in the sheet. You can created a new column to ensure you are calculating on your local time. See my video here on how to do this:
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thank you Darren, it worked!
-
@Clayton Ferreira Great! glad I could help :). It helps to have some videos I can pull out and share haha.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!