-
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…
-
Working with dependencies is a nightmare
Dear Smartsheet, I have a two change requests, because at the moment working with dependencies is really inefficient and time consuming: 1. Auto calculate lag when creating dependencies: when I create a dependency it automatically changes start or end dates. This is very annoying and time consuming because you always have…
-
Count IF Between Dates in Excel based on a name
Hello, I want to count the cells that contain a certain name in the assigned to column on one sheet only if the task start date is within a certain date range i.e the current week. For example, count how many times the "Assigned To" column on Project Plan sheet contains the name John Smith The two sheets are Project Plan &…
