-
Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
-
Exporting Report's with Grouping
I have researched that currently we cannot export to pdf or excel in the grouping format that it shows in the Report. I have noticed that this has been discussed and mentioned for a few years but little information or anything to suggest it is actually being worked on. When will this be updated/timeline? As I unfortunately…
-
Can I set an export schedule for every 5th WORKING day?
When sending up exporting schedules on reports or sheets, is it possible to have something go out every 5th WORKING day of the month? I see the option for every 5th day, but I know that includes weekends. Is there a way around this? Screenshot for what I am referring to:
-
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…