-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
Smartsheet Support Issue
I'm currently having issues with my Smartsheet environment. I pay $72/mo for 3 licenses when I only need one, yet when I have issues my support ticket has remained open for 2 weeks without being assigned. I've looked for help within the community, however when I posted my question a simple response by a random user marked…
-
Contact List Type Time Outs
Has anyone been experiencing any difficulty when you add a Contact Column type and try to add names? Seems to be happening on all my Smartsheets instances. Two separate accounts on two separate machines, only on the contact column when I try searching for names. Basically when I go to add a name for the drop down this is a…
-
Burndown Chart
Hi Everyone, I have a question about how to drive a burndown report in a Project summary: I've built a burndown sheet that contains the Application Name, Baseline Finish, and Actual Finish dates. (Those three columns are linked to other project schedule sheets.) I've also built a Cutover Date column that lists every…
-
Resource Allocation and Output Tracking in RM
Good day, We recently encountered a situation on our manufacturing floor where a bottleneck in one area was impacting downstream processes. To address this, we explored options for reallocating cross-trained employees across the facility. Each workstation produces a fixed volume of product based on the number of operators…
-
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
-
Dynamic Dropdown
Hello, I maintain a Resource Tracker which includes multiple Resource Names and Vendors. Resources are added and removed on a daily basis. I created a Forecast Tracker for each workstream to update on a monthly basis (total of 12 Workstreams). I'm trying to find a way of keeping both dropdowns 'Resource Name' and 'Vendor…
-
Operations Intake, portfolio & capacity management
I’m a fairly experienced SS user looking for advice or automation tips that have really transformed your workflow. We currently have an intake form submitted by our field team, which populates our master tracker. After submission, managers review these entries and assign them to team members. What are the best practices or…
-
Need Help Transforming an Excel Checklist into a Smartsheet Form
Hello Smartsheets Community, I need some help in taking the attached Excel Checklist and turning it into a form. The checklist is broken out by category and then by "need" and "want." What is the best way that I can layout this checklist into a Smartsheets form? Any help / ideas would be greatly appreciate it!…
-
Smartsheet as a Data Connector
I was able to utilize the ease of use of Smartsheet forms to help both the end user and our management team by utilizing the Smartsheet as a data connector option in tableau to visualize in realtime current issues and updates to our account which streamlined responses to current issues.