-
formulas doesnt work when updating data from external source
I'm using Appsheet integration to extend the functionality in forms. I encountered a problem when trying to use the SUM formula - when a data is updated inside the columns from appsheet or another source (i only updating numbers) the formula in smartsheet doesn't recognise it and when trying to sum the numbers it shows as…
-
Dynamic View-Logic Section not working for New Entries
Hi, Due to forms not having conditional logic built in I figured I would try to use dynamic view logic and have people create their entries there rather than through a form. I am trying to say if you choose this value hide these fields which I have setup up in the logic section. Although, when I go to create a new entry…
-
Struggling with creating charts on a Smartsheet dashboard
Hi - I am really struggling with the steps I need to take to convert a smartsheet with incoming form data into charts that reflect that data. I've gotten as far as creating sheet summary fields using COUNTIF formulas, then creating a report from those, then creating a simple bar chart from the report, but I can't figure…
-
How to troubleshoot Jira to Smartsheet connector errors
Hi all, I am receiving a lot of errors since I connected our Jira instance to Smartsheet. When the error appears in the Sync Error column, it is somewhat easy to understand. This one below that I receive in my inbox is harder for me to decipher. It makes mention of a column, but in the email it only references the…
-
How do I get a hyperlink to be copied to the target in a datamesh
I set up a datamesh. The source has a text column that contains hyperlinks to SmartSheets. When I run the datamesh, only the text of the hyperlink is copied to the target. I lose the hyperlink itself. Is there a way to have the actual hyperlink copied to the target?
-
Using 2 or More Data Uploader Workflows for 1 Target Sheet
Hi, I've tried googling an answer but not found the right solution, I'm hoping the community can help. Is it possible to have two or more data uploader workflows feed into 1 target sheet. Currently, I have one Master Inventory Sheet that is fed by three external excel documents. A majority of the data is updated daily via…
-
Second tile in 1 program v. 2nd program
I work with a corporate division which has 1 blueprint tile in their own Control Center program. A second division in the same corporation shares data with the first division and wants to purchase control center. I understand 2 tiles can be linked, but can 2 separate programs be linked to share data? In other words, is it…
-
How to Data Mesh comments and files?
Hi, I'm data meshing some sheets and I'd like to be able to mesh the files (photos) from a source sheet to the master sheet. Is this possible?
-
Formatting in Calendar App
When using bullet points in Calendar app, is there a way to break the line so that each bullet point would show in separate lines. At the moment, all content displays without line breaks in the Calendar App.
-
Pivot data
HI , can some one please help on- using pivot app - i am able to report on data set from a smartsheet on counts of rows on different status but We want to achieve functionality like pivot in Excel where in from pivot sheet - they can click on any counts to see only those rows from base sheet please help!
