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 t…
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, addresse…
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 …
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 for…
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 …
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. T…
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 sc…
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 get…
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…
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 …