-
Update SMARTSHEET using Power Automate
Hello, I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET? Thanks, Shahara
-
How to combine cell change notification and Data Shuttle
Hello Community, does anyone has an idea to solve the following problem? I have a data shuttle running every night, pulling information from an excel spreadsheet into a sheet (let's call it sheet 1). Do to the fact that there is no unique identifier in that Excel sheet, Data Shuttle completely replaces all the entries in…
-
SmartSheet Jira Connector
Hi Team, We are trying to integrate SmartSheet into Jira, however when looking at "Jira Connector by Smartsheet" I see the following: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet/version-history We are running Jira Cloud. "version":"1001.0.0-SNAPSHOT", "versionNumbers":[1001,0,0],…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Default view card or calendar for Teams integration
Hi there, I attempted to see if there was a solution for this out there, but no such luck. Hoping this group may be able to help... I recently integrated some sheets to a Microsoft Teams channel. The sheets in question when shared in Smartsheet are Card view or Calendar view rather than the standard grid. When integrating…
-
Document Generation/Dynamic Views & Conditional Formatting
How can I set up a generated PDF document to carry over the conditional formatting from my grid? Can the Dynamic View also show the conditional formatting applied to the grid? This works for reports but I haven't been able to figure out how to set the document or view up to show the conditional formatting in the grid...…
-
Searching a sheet from a workapp
We have a Workapp for our field personnel to look up information from their phones as they do not have computers. One of the items in the workapp is a sheet with requirements per location, and we have over 1300 locations. Our users are unable to use the search functionality on their phones unless they have admin…
-
Restricting views in Dynamic View by filter
I have a smartsheet that contains task records for for different departments. I would like to create a Dynamic View for each department that everyone in the specific department can see that only contains the records associated with that department. I can create the filter without a problem, but when I try to Restrict view…
-
Is it possible to use proofs with a Dynamic View?
I have created a Dynamic View to allow a set of reviewers access to certain rows in my sheet which have documents assoicated with the row that need to be reviewed, commented on and proofed. I wanted to use the new Proof functionality to allow the reviewers to comment in the document. How do I give the reviewers access to…
-
How can I change the date format in Dynamic View?
I have all my Smartsheet sheets with the date format like DD/MMM/YYYY but when I create the Dynamic Views the date format like DD/MM/YY. Someone can help me correct this to reflect exactly the same format as my sheets? My sheet My Dynamic View