-
Automate Status Change Between 2 Sheets
I have two sheets, both with Status columns. Ideally, when the status in sheet B changes, I would like the status in sheet A to change. For example, if my tester (sheet B) changes the status to "Test Failed", I would like my Defect Critical status change to "To Be Reviewed" Can this be done through automation or do I need…
-
How are you managing agendas and meeting notes? Ran into character limit on dashboard
We've been using the dashboard feature leveraging the rich text widget to post our weekly meeting agendas and then follow-up notes. It's been great since we can live collaborate with the client on these and it doesn't have to be a separate word or one note document. We tried do a sheet and it just doesn't look nice for…
-
Best Practice: Managing Different Types of Work (One Sheet vs Multiple Sheets)
Hi there. I recently migrated my L&D team's work management into Smartsheet. We're using it to track the following work: training new hires, working on projects, developing eLearning courses, and developing documentation. We're only a few months in, and it's working very well, but we're seeing some undesired effects that…
-
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…
-
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.