-
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…
-
Published Sheets
I understand that Published Sheets are dynamic and will reflect any changes to the sheet. However, what about in terms of the Project Settings? We have a published sheet that is displaying on a common monitor. When the sheet was published, the Timeline Display was set to "Open to today's date". Since then we have unchecked…
-
RYG Balls associated with Dates
I have search and tried multiple expressions and cant seem to get things to work correctly. I have columns: Estimated Start Date Actual Start Date Estimated Completion Current Finish Date Actual Completion Date What I would like is the RYG Ball to be blank for any row that does not contain an [actual start date]. Green if…
-
Exporting to Excel - Question at the end of the discussion
Exporting Excel formulas Alejandro Silva June 11, 2015 4:28 pm I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to…
-
Can I clean up my FORM email Text?
HELLO ALL, I am a newbie and this is my first submission, thanks for the comments. I created a form which watches the Audio Visual Rooms and reports to the Smartsheet when a problem occurs. It also sends an email to the helpdesk when a certain field (for emails) is checked. The email is generated from the AV SmartSheet and…
