-
Form for many parts at once
We have a form that a technician fills out when a part breaks. It then send out auto update to parts department to fill out the price of what the technician enters. However sometimes there are many parts that needs to be replaced on one machine.What is the best way to make the technical be able to fill out the parts for…
-
How to create a master contact list to keep sheet contact lists up to date
Is there a way to use an export of User List from the User Management list in Smartsheet Admin Center to create a master list that can be used to automatically update Contact List columns with a common column name and function across many sheets? Right now, I am manually keeping individual sheet contact lists updated as…
-
Find missing/deleted scenarions
I have 2 sets of scenarios. The first set is a full original set. The second set has been modified, some scenarios might have been deleted. How do I determine which scenarios were deleted between the full set and the modified set. Each scenario does have a unique scenario ID. If possible, I would like to determine the…
-
Recreating the Countermeasure and Task Spreadsheet
I am having problems recreating this sheet where multiple users (without logins) can update their project notes weekly on any progress made. I want it to associate the Countermeasure - Project - Task. I want to tie it to a A3 Dashboard (for each project showing the amount of task/ projects completed, inprogress, etc.
-
Tracking Best Practice
I want to track the scheduled time vs. actual time of tasks across multiple projects. The tasks are the same for all projects, I'm just looking for any variations in the time scheduled vs. completed in order to determine if we need to allow for more or less time to complete that task. Do you have any recommendations?
-
PM III Opportunity at Centene Corporation
Hello Smartsheet SME's — Centene is hiring for a PM role that will be expected to dedicate half their time to developing, managing, and integrating Smartsheet (using control center) with our PMO Portfolio level PowerBi dashboards. Please see below for a link to the external job posting and/or apply if you are…
-
Additional Currencies
We are struggling with our budget tracking for projects in our APAC region, as their local invoicing currencies aren't included in Smartsheet. Some examples are: Malaysian Ringgit (MYR) Thai Baht (THB) We often convert between local currency and USD, so it can be quite confusing to not have an option for some local…
-
Work Insights
Hello, having difficulty with Work Insights not capturing all rows. I've confirmed that all filters are cleared and tried updating the charts manually. Any ideas? I have ~90 rows but Work Insights are only capturing ~79.
-
Collections or Groups of sheets & workspaces
In addition to the workspaces that I own, I get shared to individual sheets (listed under 'sheets' instead of workspaces) and partial sheets within other workspaces I do not have full admin rights. This poses the inability to move shared sheets to my workspace and reorganize sheets or partial workspaces owned by others…
-
Is there a way to create a column that re-numbers automatically when rows are moved around?
I feel silly that I cannot seem to figure this out. Is there a way that a column can contain a number that updates automatically when rows are moved around? For example, if the rows are numbered 1, 2, and 3 - in order, and then I move row 3 in between rows 1 and 2, I want that cell to automatically update to become 2 and…