-
Linking to external location
Is there way to provide hyperlink of any cell to local drive on the machine likewise in Excel we have that facility ?
-
Opening Drop Box attachments via cell phone app
All attachments for my Smartsheet program are from my Drop Box file on my computer. Staff with access have not had issue accessing them within our network. A staff member has indicated he was unable to open a file from the job site via his cell phone. I have reviewed Drop Box Help and SS Community and have not found the…
-
Option to create Multiple Parent Roll up functionality? I created for Actual timeline by using Proje
Hi, Can anyone help me on this. I have enabled Parent Roll up functionality for Actual timeline by using project setting as refer to 1st screen shot. Same way I tried to add duration and timeline for Planned Time line but it is not auto calculating as i notice at single time we can setup parent roll up functionality for…
-
New form data get inputted after two three rows
Hi, I am facing an issue..the moment I input new form I could see the information submitted two three rows below the last updated rows..can you please advise. How to fix the issue Row 1 and 2 I inputted yesterday When I tried to create a new form today I got updated in row 5 ..ideally it should come in row 3.
-
Protecting Special column when importing
Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base. In that sheet I have a column (RYG balls) with a formula to calculate overdue estimates. But every time that I import the new data, that column is crushed. I even added it at the far end beyond the imported data parameter. Is there a way…
-
Counting and Dates
Hello, I have been trying to come up with a formula that works. I am trying to count all of the "request" I have through a certain date. The form that I am using to take requests and the sheet that I am tracking metrics are separate. =IF(AND({Intake}) > DATE(2018, 12, 1), {Intake} < DATE(2018, 12, 31)) This is what I am…
-
Urgent help needed - raport self locked all columns
Hi All, I have a sheet which is reported for two, exactly the same users. They have the same level of access to the report (as editors with no share options) as well as to the main sheet, but for some reason, one of them just lost ability to edit anything! All columns are shown as locked! Do you have any idea what could…
-
Submitting a Form
We have a finance form that will submit vendor, invoice, amount etc. in to our sheet. My question is how can I get the information in the form to fall under the appropriate vendor? Right now, the form information goes to the bottom of the sheet and I know that you can set it for the top of the sheet as well. So for…
-
how to take the new Filter/Share line off?
Hello everybody, Does anybody know how to take this annoying new "Filter/Share" line down? To permanently hide it. Just a waste of space for us ;( Thanks,
-
Summarize data for graphing
Hi, I have a large data table used an experiment tracker, and I'd like to summarize columns to graph on the dashboard. The first column is a drop down list called vessel type, which has 12 different vessels. The second column is a drop down of pass, fail, and pending. I know I can use the COUNTIF to tally the number of…
