-
Import contacts for templates
After importing contacts (csv file) into a sheet we're using as a template and then sharing that sheet for others to use, is it possible for the contacts to remain in the template? I am trying to eliminate every smartsheet user from having to import contacts individually and simply do the work upfront on our templates.
-
Help Desk Dashboard
Has anyone created a Dashboard that links to a Help Desk SmartSheet? I'd like to be able to have a Dashboard that shows users the status of all tickets submitted, so that multiple tickets aren't submitted for the same issue.
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Multiple Selections from a Drop Down
Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple…
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…
-
REALLY don't like the new layout!
The new look/functionality of the sheet is much less friendly. Takes a lot more clicks to get through and I now always have to close the left pane to see my sheet properly. Also, the left pane list keeps changing so I have to hunt for my sheet each time. When you had the tabs at the top I knew where to find my sheets…
-
Security assessment fields for each project
Our security certification requires that we provide answers to several key security questions for every project (risk assessment, project justification, etc) and I was wondering what the best way to handle that in Smartsheet would be. They're not really tasks, since it's just several sentences for each that need to be…
-
Widget filter, IF statement, or what?
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?