-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Data Shuttle Export/Import
Hello, I am trying to use Data Shuttle to copy information from one column and paste it into another column by first exporting the master sheet then run an import of that export and it seems to be clearing all of my data or not uploading new data. The export currently exports all data with no filters. Below is the Import…
-
Excel Export Parameters - Data Shuttle
Hello Dear Smartsheet Community I would like to use my Smartsheet Data, to dynamically populate Email content… This being not "nicely" supported out of the box, I want to use a 3rd party app (Ablebits - Merge Email) which easily do this from Excel files pulled from "OneDrive". For this to work, I plan on upgrading to "Data…
-
Reports - When exported to PDF
When a report with groups columns exported to PDF, PDF doesn't show the report with grouped columns. It just shows a list of rows. How do I get the report what it displayed in the PDF? Don't want screen grab like solutions. Exported PDF: As you can see Project Manager, Project Name and Project Health columns (Grouped) were…
-
copy data from excel and enter into smartsheet with multiselect column
I have a report in Excel that I want to transfer regularly over into Smartsheet for dashboard reporting. One of the columns is a dropdown list that allows for multiple values. I am having trouble formatting it to where when copied from Excel, it paste into Smartsheet as the selected values. When I copy/paste, the cells…
-
Help converting Excel formula to Smartsheet
I imported an Excel file into Smartsheet, and am stuck trying to convert this Excel formula into a functioning Smartsheet one. I know some of these functions are not available in Smartsheet. However, I've tried a lot of different formulas and am still having trouble. I've even tried using ChatGPT and it's proven to be…
-
Importação de Dados
Pessoal, Tenho uma base de funcionários que constantemente é atualizada, estou usando outro Smart para puxar as informações dessa base de funcionários. Com as atualizações na base de funcionários preciso importar os dados sobrepondo a base anterior. Porém identifiquei que para importação de dados consigo apenas criar um…
-
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Import Excel to existing Smartsheet & keep existing smartsheet columns
I've been copying/pasting excel data into an existing smartsheet. It's not a lot of rows but I have column formulas in smartsheet that I want to keep. If I import the excel to my existing that has 10 columns but my smartsheet has 15 columns (5 are the formula columns) is there a way to keep these 5 columns while importing…
-
IDEA: Auto-Populate New Users' Profile info from Outlook GAL or OKTA, OR Import info into contact
Please make it possible to Sync the Personal Settings>Profile details with an outside service, such as Outlook 365 Global Address List (Admin), OKTA, etc, so that the settings below are automatically populated. Since users will likely want to update the data or fill-in missing data, we'd only want it to pull the data into…