-
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
-
Viewing Cell History of Linked-In Cell
Our users are wanting to see real cell history on a cell that is linked in from another sheet. If you right-click the cell, it shows the history, but the user is shown as "Cell Link User", which makes sense. When you double-click the cell, it opens a pop-up with the sheet/cell it is linked from. It is not possible to…
-
An error has occurred in the application. Please log out and log back into the application before c
Hi There We have call Smart sheet a number of time, left about 5 messages and still waiting on a reply I have also emailed as seen below. Regards Jacqueline Niemand Hi there, We Emailed over 10 hours ago and it’s still coming up with the following error we have loss a whole day with a number of staff not being able to done…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
Auto populate worksheet through hyperlinks built with web forms
My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
