Return cell value
I would like this cell, Actual Ship Date, at the top to return the date in row 213 Task Start Date column.
So the value should return 9/21/23.
In excel, all I have to do it = and click on the cell. How do I do this in Smartsheet?
Best Answers
-
Hi Katie,
If I understand your ask what you are looking for is a cell reference - you want one cell to be equivalent to another in the same sheet.
You should be able to do it the same way you do it in excel , click the cell where you want the data to go, then "=" and then click on the cell that you will pull the data from - that should bring the value over from the other cell.
Make sure you don't have a column constraint to drop specific dropdown values and you are using the same column type - in other words - if a column is a text column, you will get an error if you try to link it to cell for a date column.
-
I had to make a completely new date column for it to work but this is not ideal since the balance of the column will be blank. :(
Answers
-
Hi Katie,
If I understand your ask what you are looking for is a cell reference - you want one cell to be equivalent to another in the same sheet.
You should be able to do it the same way you do it in excel , click the cell where you want the data to go, then "=" and then click on the cell that you will pull the data from - that should bring the value over from the other cell.
Make sure you don't have a column constraint to drop specific dropdown values and you are using the same column type - in other words - if a column is a text column, you will get an error if you try to link it to cell for a date column.
-
No that is not working and it is a date column and I am trying to return a date cell.
-
I had to make a completely new date column for it to work but this is not ideal since the balance of the column will be blank. :(
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!