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?
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. :(
No that is not working and it is a date column and I am trying to return a date cell.
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
