Change Dates w/ CNT F
I can't seem to use the "CTRL F" function to change the years in the dates columns. For instance, I want to change Dec 25, 2023 to Dec 25, 2024. All I need to change is "2023" to "2024". Nothing seems to bring up the Dec 25, 2023 date no matter how I search. Can someone please let me know how to find such dates and then replace in this case only the year?
Best Answer
-
Paul Newcome ✭✭✭✭✭✭You will need to enter the full date in the search and have it replace with a full date.
Answers
-
Paul Newcome ✭✭✭✭✭✭
I just tried it in a sheet with no problem. Can you provide screenshots to show exactly what steps you are taking?
-
DieHard Jets ✭✭
Using the "F" function it only goes to the cells that are text cells that contain "2023". I tried a few other ways with the F function but it never goes to a date column.
Thanks.
-
Paul Newcome ✭✭✭✭✭✭
You will need to enter the full date in the search and have it replace with a full date.
-
DieHard Jets ✭✭
Thanks Paul. Only wish all the dates would be the same in 2024 but for the most part I have like 150 tasks and very few have the same dates in 2023. That will carry over to 2024.
-
Paul Newcome ✭✭✭✭✭✭
How often will you need to update the year? Is it something you will regularly be doing? We may be able to set up some helper columns and use a formula to output the date based on those helper columns. Since the year would be separate, you would be able to use the CTRL + F to find and replace the year in groups the way you are wanting.
Categories
I hope you're well and safe!<\/p>
If you're using the DocuSign integration, you can have status columns indicating the different stages.<\/p>
More info.<\/p>
Would that work\/help?<\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112057,"type":"question","name":"Has my automation run?","excerpt":"Hi How can if see if certain owners on my sheet have received their automatic email? There must be a history somewhere Thank you","snippet":"Hi How can if see if certain owners on my sheet have received their automatic email? There must be a history somewhere Thank you","categoryID":321,"dateInserted":"2023-10-24T03:41:55+00:00","dateUpdated":null,"dateLastComment":"2023-10-24T21:57:49+00:00","insertUserID":168171,"insertUser":{"userID":168171,"name":"Laura G","title":"Mrs","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T23:53:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168171,"lastUser":{"userID":168171,"name":"Laura G","title":"Mrs","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T23:53:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":44,"score":null,"hot":3396304784,"url":"https:\/\/community.smartsheet.com\/discussion\/112057\/has-my-automation-run","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112057\/has-my-automation-run","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":112057,"commentID":401496,"name":"Re: Has my automation run?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401496#Comment_401496","dateInserted":"2023-10-24T21:57:49+00:00","insertUserID":168171,"insertUser":{"userID":168171,"name":"Laura G","title":"Mrs","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-24T23:53:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-25T00:28:12+00:00","dateAnswered":"2023-10-24T14:30:37+00:00","acceptedAnswers":[{"commentID":401370,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/E3SK6GNMQ546\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
