-
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…
-
setting up a user for the 2nd time
I am trying to set up a new user xxxx.xxxxx1@nhs.net, he was originally set up at xxxxx.xxxxx@nhs.net, but was deleted as he didn’t need it anymore. He now has a need to use Smartsheet again, but now has a new email address, which is the same but with a no 1 after this name. But when I put in the new email it comes up with…
-
Add a comment to the column
Hello, I'm wondering if I add a comment to the each column? like description. I would like to add some description to each column title when users drag. I usually use a lot of abbreviation on the column title. I want users to easily know what does the column title means. I tried to find the way. However, I couldn't find it…
-
SmartSheet Live Data Connector (Excel)
It works! Was able to connect to smartsheet from excel using the live data connector. The SM table exists as a read only table on a tab in the sheet and I can use index/match to pull values out of the table. This lets me keep one data file in smartsheet and use it across multiple excel sheets (stored on box.com). Used an…
