-
Dashboard Creation Using a Form
I have a form that I submit to stakeholders that captures CSAT data. The form specifically captures the CSAT score, the stakeholder product, the internal team that worked on it (e.g., Team A, Team B, and Team C), and the stakeholder's name. The date the form is submitted is also included and auto-populated in another…
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Import data into a datatable from power automate
I am using power automate to get data from my SQL server database. I want to then push that data to a smartsheet datatable. I currently am able to push the data to a smartsheet using insert row in power automate. another option would be to push the data directly from SQL database to a datatable. I am new to smartsheets so…
-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…
-
Large Data Set Solution
Hello, I have created a table to view weekly data displaying how many cases are worked vs hours worked. This table is using several SUMIFS fuctions to pull from 3 separate source sheets. My issue is these source sheets are updated every 2 weeks with roughly 2,500 rows each. So far, I have only done weeks 3-6, skipping the…
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
-
Connection between Data Table and Control Center
I have a lot of project data stored in a data table. As I have Control Center generate new projects, I would like to be able to pull reports or information from Data Table to populate sheets in the project. This would include creating a table connection table to a sheet in my Blueprint, then having it populate the…
-
DataTable Variable
I have a DataTable containing time entries from 2023. I would like to bring them into each project and I can do that by manually connecting a sheet in each project to the DataTable and then filtering for the needed information. Currently my projects are built using Control Center. Is there a way where I can create a sheet…
-
Separating Table by Week
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I…
-
Archiving Data
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces…