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.

Find more posts tagged with

Construction

Formulas

Support

Comments

Andrée Starå

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

@Help

Here is a picture of what it looks like. Cell linking doesn't give me the option of linking from the same sheet.

Andrée Starå

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

@Help

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)

@Help

I also forgot to mention that the "start" column is linked with the dependency settings.

Andrée Starå

Yes, that's what I suspected, but I got confused and mixed the columns up.

Sorry about that!

Best,

Andrée

Constantin Hapau

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

Andrée Starå

Hi @Constantin Hapau

I hope you're well and safe!

Please have a look at my post below with a method I developed.

More info:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Categorize If Project Completed On Time
Hi - I have most of the formula working below except for when a project is not completed yet and the Actual End Date is not inputted, and Helper (Difference in Days) is not calculated. When the Helper (Difference in Days) is blank, I wanted to Helper (Completed) column to pull "in progress" Below is current formula with…
SUMIFS help!
Hello! I've attached a screenshot of what I'm trying to do. Basically, I want to do a SUM formula on the range int eh screenshot IF the left column is "Supplemental" and the top row is Monday-Friday. I thought the way I had set it up was right, but I'm getting INCORRECT ARGUMENT SET. Any help would be appreciated! Thank…
Index/Collect function returns #INVALID VALUE only when the formula comes back with an empty value
Hi folks! I'm trying to reference a cross-sheet cell value using the following formula: =INDEX(COLLECT({PM Practice Training Completion: Completion Date}, {PM Practice Training Completion data: LXP ID}, [LXP Course ID]@row , {PM Practice Training Completion data: Username}, "Test User"), 1) This formula is located in a…