-
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…
-
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…
-
Sort and filter on a report in Smartsheet without being an Admin on the connected sheet
Is there a work around to sort and filter on a report in Smartsheet without being an Admin in the sheet it is connected to? Even when the person is an Admin on the report
-
How do I have tiered authorizations?
https://us.v-cdn.net/6031209/uploads/9SX9INL2K24P/what-i-need-from-smartsheet.docx As noted in the attachment, what I am looking for is a system of sign-offs where each person can sign off on a document and then it automatically fowards to the next person in line OR if the have changes, it gets sent back to me.