-
Cell linking
I have two sheets with several common columns. One of which is closing dates. I want sheet B closing date column to look at sheet A and pull the closing date for each row. The sheets have common columns for lot# which would be the field to index on. In other words, if lot# 1 is closing on 4-1-18 this gets entered into…
-
Batch rename hyperlinks
Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do this one by one. (multiple sheets with the same set up). Thanks
-
Populating Parent with Child Cell Info
I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible. We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair…
-
Cross Linking Date Cells
Hi I don't know if this is a bug or not but, I have a summary sheet which has a column set as Text/Number I link into it from a number of sheets, the links can be contact names, descriptions, addresses etc, I have two cells in the column I want to populate with a start and an end date taken from a project plan sheet. When…
-
Grabbing excel fields and displaying value in a smartsheet field
I'm trying to figure this out.... I have 100's of excel files that are not formatted in rows and columns but these excel files all have the same fields and headers configured like a report. I want to "connect" these cells of each of the files to populate a row with columns representing the fields of the excel field name.…
-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
I'm looking to hyperlink words in a dashboard to a cell in a sheet?
Hi, I built out a dashboard with text boxes and need to link a specific word in the text box to a specific cell in a sheet. Is there a way to do this? I know that you can link cell to cell from sheet to sheet or can link to a sheet from the dashboard, but I cannot figure out how to link to a cell from a dashboard. Thank…
-
Turnaround time for the month of...
I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…
-
Linked Cells and Indentation
I'm pretty new to Smartsheet so please forgive any ignorance I may have. I have a program with three providers managing their portion of the program. I want to have each provider maintain their own schedule in their own sheet and have a master sheet that includes all the tasks that I'm managing as well as links to all the…
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…