-
Cross sheet refrence formulas on a metric sheet keep showing errors until the sheet is opened
I have 5 large sheets (10,000 rows, 45 columns) mostly populated by DataTable that I'm collecting metrics from on separate metric sheets (1 DT sheet → 1 metric sheet). The metric sheets collect the metrics via cross-sheet references. Some of the formulas "break" (breaking the dashboard visuals) but quickly fix themselves…
-
Need to be able to organize summary sheet data for dashboard widgets
I have over 100 sheet summary data sets that I have nicely organized on the main smartsheet I'm pulling data from. However, when I try to set up widgets using the same data, there is no rhyme or reason to how they are organized. It's not even alphanumerical, so I have to go searching for all the matching sets. For example,…
-
DataTable: Creator Now Listed
Hi Community, Users can now see the creator when viewing a list of DataTables they have created or are shared to, enabling System Admins to better manage DataTables across their organization. DataTable is available to licensed users with Advance Gold or Platinum. You can also stay informed by subscribing to receive product…
-
Possible to have a sheet automatically built from another sheet using a formula?
This is probably not possible, but this group is amazing and may have other ideas. I have an ORDER sheet that list various products and services (ITEM DESCRIPTION) into 5 different MARKET(s). This could be 100's or 1,000's of line items with many duplicates. Is it possible to write a formula that would go through each…
-
Data Shuttle + Data Table: Move Row Repopulation
I have a large Data Table that gets fueled daily with fresh information. There is a 'KEY' column that uniquely identifies each ROW of data. Using a Data Shuttle, I am fueling a regular sheet with only SOME of the data from the Data Table. Unfortunately I cannot find a way to filter the Table with ANY (and) ALL logic. What…
-
Can you have a live connector from one smartsheet to another smartsheet?
Is there a way to have live data from one smartsheet to another smartsheet? let's say that one row from the "child" smartsheet is being updated and the "master" smartsheet gets updated based on the values from the "child" or vice versa
-
Identifying current data in DataTable
Does anyone have a good way to identify good records in DataTable? DataTables can be updated from an external data source using Data Shuttle but there is no way to automatically remove DataTable records that are no longer in the source data. This means DataTables will contain bad data. My current workaround is to include a…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
-
Add Delete Rows that Don't Match Filter Criteria Option for DataTable
Because there is no way to delete DataTable entries from a Data Shuttle workflow, I have to abandon the use of DataTable. Because I am unable to delete entries via Data Shuttle, DataTable connections have been pushing out of date and incorrect information to my sheets. I am hoping the DataTable and Data Shuttle product…
-
Update Dropdown List Options
Are there any recommendations on how to maintain dropdown options for a Control Center template? We have a Change Log template where one of the columns is 'Impacted Applications' with a dropdown column property. The list of options change periodically and each time that list changes, we currently need to rollout a global…
