-
Share into a Workspace
Hello, I have been looking for the solution to share into a Workspace. I see the Workspace and I have Editor access. I do not see the options on the sharing sheet checkbox or under Home from the screenshot. Please advise if I am missing some settings. Thank you! Tom
-
How do you pull form data in sights directly from a sheet?
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?] I have attached a screen shot to support above. Thanks
-
Page break / separation between years / header
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is there a way to make the font larger and the width of the column itself larger in just the…
-
Type selected - allows certain columns to be updated
The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example: Vendor 1 Type Critical All doc type columns would…
-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
-
Importing auto numbered columns
I want to be able to import an excel file that will create auto numbered columns (date created and auto-numbered). Is this possible? What I am trying to do is as follows: I have created a template to make training quizzes for different departments. I want to make an outline in excel where employees can type in a list of…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
Multiple colors applied to one cell
I am pulling data from an Excel sheet listing resources. These resources (cells) are color-coded based on availability, training, etc. In a couple of instances, some resources might be available AND billable and, consequently, require 2 different colors in the cell (from the legend). In Excel, there is the ability to…
