Formula to copy the information of one cell into a different cell

Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up as 06/19/19. This is all taking place in one same sheet, maybe there is a different type of solution.
Comments
-
Hi,
Have you tried cell-linking?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Here is a picture of what it looks like. Cell linking doesn't give me the option of linking from the same sheet.
-
Try this.
In the Start cell on row 3.
=[Concept Start Date]1
You can also type = and then click on the cell you want to show in the cell.
Did it work?
Best,
Andrée
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.
-
It didn't, I think it doesn't take it as a formula because after typing the formula and pressing enter, the cell shows what I had just typed(picture1) and when I double click on the cell it added a symbol before the = sign( picture2)
-
I also forgot to mention that the "start" column is linked with the dependency settings.
-
Yes, that's what I suspected, but I got confused and mixed the columns up.
Sorry about that!
Best,
Andrée
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.
-
HI Andree, so what is the solution for this please. need to do the same like copy a date from one date cell to an other date cell and it doesn't work - very frustrating . also even the todays() date doesnt work
thanks
-
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
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 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.
-
@Help , I need to have a cell recording DATE & TIME when a checkbox is checked. The "Modified date" type doesn't work because the row will have other user interactions after checking this box. So, I have to work around with a workflow to Copy the row when the box is checked to another Sheet, so I have a Modified date column recording when the box is checked. Now, on the original sheet, I tried to use VLOOKUP to return the "Date & Time" on a Text type of column so I could finally have the Date & Time in which the check box was checked. However, the VLOOKUP doesn't work because the Date & Time from the Modified date is incompatible with the Text type of the column. Changing the type of column to "Date" doesn't work because it loses the Time; it only returns the Date. What can I do in this case?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!