Super Simple: need to reference a date from one cell to another

Pamela Wagner

In my project plan, I am using the Start/Finish as my baseline and then Actual Start/Actual Finish as my actuals. I would like to have a formula for my actual start be the baseline start so all I need do is then put in the Actual Finish. I need a formula to copy the date in the Start column into the Actual Start. For the life of me I can't get it to work. In XLS its super simple: =D3 but that same logic doesn't seem to work in Smartsheet.

Jon Mark H

Hey Pamela!

The formula should be: =Start@row - this will pull the Date from the Start date row (assuming it's called "Start" & that your "Actual Start" column is also formatted as a Date Column.

If you don't want it working on each row - you can do a specific reference, like D3 in Excel - this would just be:

=Start3

Let me know if this helps or if you have any further questions or issues!

-Jon Mark

Jon Mark H

Hey Pamela!

The formula should be: =Start@row - this will pull the Date from the Start date row (assuming it's called "Start" & that your "Actual Start" column is also formatted as a Date Column.

If you don't want it working on each row - you can do a specific reference, like D3 in Excel - this would just be:

=Start3

Let me know if this helps or if you have any further questions or issues!

-Jon Mark

Pamela Wagner

Holy moly! Told you it was easy! I missed the "@row". Thanks much!

Jon Mark H

@Pamela Wagner

Glad I could help!

kmarusina

I could not make this suggestion to work. When I type " =row20" or type "=start@20" or type " =start@row20" it just stays that way, does not pull the formula

Genevieve P.

Hey @kmarusina

The way to reference a cell is the [Column Name] first, then the row number after.

So if your column is "Start Date" and you want to reference row 20 it would look like:

=[Start Date]20

If you're referencing a column just called "Start" with no spaces, and you want to look at row 20, it would look like this:

=Start20

Now if you're referencing a cell in this same row, you don't have to write a number, this is when you use @row, or "at this row"!

=[Start Date]@row

or

=Start@row

See: Create a cell or column reference in a formula

Cheers,

Genevieve