-
Finding Duplicates across multiple sheets?
Hello! Need helping find duplicates across multiple sheets in one column and displaying them in a report. Any help is much appreciated, thank you!
-
data mesh
Hi, I would like know why a yellow blox appear when I would like to do a data Mesh
-
Add an entry by emailing it
i have access to the smartsheet calendar via outlook and have provided instructions to leadership to do the same. i am the only one with a smartsheet account, so is it possible that when they set up new meetings, they can add to the sheet via an email address (the same way when one sets up a new meeting, they add the…
-
Issue with DyanmicView
Hello, Using DynamicView, I couldn't show the column description. The columns name is limited in characters and I need to explain the meanings of each column. Also, I tried to do a helper row but the cell is limited to 20 contacts so I can't show the helper row to all viewers. Any alternative idea? Thanks,
-
DataTable doesn't update sheet row after unique identifier changes
Hello, I have a sheet with a connection to a DataTable. The unique identifier is email addresses, sometimes I have to update the email in the sheet as it's changed. After I change it, the row's cells are not updated with data from the DataTable. I've confirmed that the DT does have the updated email and it's data points…
-
Multi-Tier Control Center | Changing Tier References
Hello Community, Has anyone solved for how to change the tier references so that you can move a lower tier to a different upper tier? Example: Market (Top Tier) | Program (Middle Tier) | Project (Bottom Tier) Given that we have to trigger the Market before the Program and the program before the Project in order to…
-
Unable to edit Blueprint in Control Center (I am Primary Lead)
Hi All, Hoping for some help that I have been unable to get from Smartsheet Support. I am the primary lead of our Blueprint, but when I go to edit the blue print I can get through the Blueprint Basics tab all the way to Profile Data Selection and then the site freezes up. While the Blueprint and provisioning work…
-
Zotero and SS integration
I'm curious if there is an integration between Zotero (a citation management tool) and SmartSheet. We collect our faculty and resident publications using Zotero because it has a lot of automation, but would like to utilize the data in SS because we can calculate various data based on that. So it there is any chance to…
-
DataShuttle adding values as strings
Hello, DataShuttle has started inputting values via upload workflows as strings rather than numbers. The source data is in normal number format, but when uploaded into Smartsheet they have a ' in front of them. This has only started occurring this week and was working normally before.
-
Use DataMesh to combine multiple sheets
I'm trying to combine multiple sheets into one master list, what is the best way do the config for this please? I want it to pull in all values from source sheets, and if the source sheets gets updated I want it to automatically update the master target sheet. Sometimes the source sheets have duplicates so I want it to…