-
%Complete forumla reflective of sub tasks Complete
I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks. For example: Parent folder with 3 subtasks Status of 1 subtask is complete Percentage complete column will reflect 33 percent complete Any help would be…
-
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
-
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…
