Product questions?
Ask it here! The community's got your back.
Discussion List
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!
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…
Outlook Calendar utilization
Hi all, How does Outlook Calendar integrate with Smartsheet? I'd like to se an overview of all the task where I am assigned. Where is my actions needed and when? Have to I use Outlook or Task manager for this? Or how are you managing your open tasks? Thanks in advance. Palle Kølln
Using Data Shuttle to take a Multi Select Dropdown to Update a Dropdown on Different Sheet
I have done some research and testing around using data shuttle to update dropdown fields. Essentially I want to take what a user selects from a multi select dropdown source sheet to update a field on a target sheet so that only the options they can see in the dropdown are what was selected on the source sheet. I'm able to…
Data Shuttle Changing 100% to 1%
When using Data Shuttle to import data from an .xlsx sheet, the decimals from that sheet that equal 100% are instead converted to 1% in Smartsheet. This issue is the same as in this Community post that has no answer or resolution: https://community.smartsheet.com/discussion/90205/data-shuttle-changing-my-100-to-1 The…
Show my the text file coming from Smartsheet Bridge
Hello, Please give me the json file coming from bridge output, the data reference is not helpful for me to create a json body to call this exact field:
Is there a way to use a global update to add a new report to previously provisioned projects?
I have created a new report (and link to that report) in my control center blueprint that will be created for new projects. However, I need to have the report created for past projects. Does anyone know if there is a way to do this with a global update? I see how you can update a new report, but not create one. Thanks.
MPP linked to Smartsheet
Hey, I would like ti link a MPP file to a Smartsheet. Qhat's the best practice to do it please?
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
Embeding forms into a dashboard that is part of a Control Center Template Folder
Hi, I'm finding difficulties when trying to embed a form into a dashboard that is part of a template folder for control center. Due to the fact that this form is embeded through a link, the form keeps it's original destination sheet when a project gets provisioned and the new dashboard gets created. In other words,…