-
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
-
Linking a drop down cell to the workflow
I have a drop down status cell on my customer sheet. I would like the info in this cell to be linked to the Workflow sheet in the status cell for each customer. I have tried to go to the Workflow status cell for a customer and link in from the customer sheet, this works and when the customer sheet status cell is changed…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
-
How long for data to update across linked cells and reports
On more than one occasion, upon updating information in one sheet, and saving and refreshing all involved sheets/reports, the data was not visible in other sheets/reports. Is this an update delay, browser caching, or something else? And, is there a general amount of time I can tell users? Two scenarios I've experienced: -…
-
Having dates change by being linked to previous dates
Hello all, Ive looked and cant find this one ( or i didnt type the right thing in search ). I have several deployemnet dates set. Im wondering if I can have all dates change if I change one above them, EXAMPLE: On 03/14/17 I have a deployment scheduled. On 03/21/17 I have a deployment scheduled. On 03/27/17 I have a…
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows. My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar…
