Copy row to another sheet - created date
Hi,
I was having 2 smartsheet and usually when there is a need the row will be copy to another sheet by using automation.
And at the new sheet I am trying to sort "created date" (the auto Number/system) as descending to let the new copy row to be on top of the smartsheet. But I found out the "created date" column was the date that created at the original smartsheet.
Is there anyway or possible to make copy row to new sheet with new auto created date? So that we can know which request is the new request that has been added in.
Thanks.
Best Answer
-
Hi @Jacelyn Lok
Hope you are fine, try to use system column (modified date ).
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Jacelyn Lok
Hope you are fine, try to use system column (modified date ).
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks Bassam. This is a good idea. Will try on it.
-
Hi Bassam,
I'm having the same issue however...what if I want to know the date that the record was copied to the new sheet even after subsequent modifications have been made to that record in the new sheet?
Is the only answer to NOT have a column of type "Created date" in the source sheet?
Thanks in advance.
-
Hi @mnemith
I hope you're well and safe!
You could add a Workflow with the Record a Date Action.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, that would.
Thank you.
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives