Super Simple: need to reference a date from one cell to another
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.
Best Answer
-
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
Answers
-
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
-
Holy moly! Told you it was easy! I missed the "@row". Thanks much!
-
Glad I could help!
-
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
-
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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!