-
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…
-
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
-
Over riding dependency per activity without deleting the tie
I am having problems holding start and finish dates for out of sequence activities that are in-progress or completed. So if the activity is in-progress or complete and not all the predecessors have completed as planned and the dates will continue to push as the predecessor pushes. I would rather not cut the tie to hold the…
-
Linked Sheets and Dragging Rows
When dragging rows to another sheet, is there a way to keep the information from the Parent sheet which to information is being pulled from? This would obviously automatically create linked cells back to the parent sheet that the information is dragged from. Is this possible? Current Process: My company is basically trying…
-
Formulas looking up data from other sheets
Is it possible to create a formula in one sheet that looks up info from another sheet? I dont mean linking cells - I need to be able to set an IF statement based on the input of one column in another sheet. You can do this in excel so im wondering if Smartsheet also allows for this.
-
Links not updating
Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y
