-
Is there a way to validate that a particular cell cannot be left blank or allow junk entries?
In our application, we have the smartsheet as the user interface to enter the data and then this data gets transported into the database by an API according to a set cadence. For data integrity purposes, I want to ensure that certain key fields should not be left blank or allowed junk values.
-
Webform question: uploading files to Box
Is it possible, using a Smartsheet web form, for the "File Attachment" widget to store the uploaded file to a designated Box.com folder? In other words, not as an file attachment to the Smartsheet row, but as a link attachment to the Box file? Otherwise, the user needs to first upload the file to the correct Box folder…
-
How to add new sheets/dashboard to all existing projects on Control Center
I have created/provisioned a few projects on Control Center and realized that we wanted to add couple more sheets and dashboards to all new projects as well as to all existing projects. It doesn't seem like the Global Update can achieve this as it can only edit information within a template in the blueprint source folder…
-
roll back to an earlier version
I seem to have lost information that was stored in the paperclip section and attachments. Can I roll back to an earlier version when I know the data was there? Can I restore an earlier version of Smartsheet?
-
Using Microsoft Flow to Send Email
Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts. I think I've got my flow set up ok but I'm…
-
Jira - Smartsheet: Some issues are taking 24 hours to feed into Smartsheet
I have a jira connector workflow set up to feed a smartsheet grid. Within the workflow, I used JQL to determine when/if an issue should flow into smartsheet (when a particular field is set to "Agent Response Pending"). Most issues feed to smartsheet between 5 minutes to 40 minutes. However, some are not feeding until the…
-
Jira Connector - Issue Key - Remove HyperLink?
Is there a way to remove the hyperlink for the Issue Key that is brought in to smartsheet via the Jira Connector?
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
UPDATE IMMEDIATELY DataMesh Frequency not updating without running manually
I have several datameshes that are set to "run immediately" and "copy and add data" and for some reason they only run when I run them manually from the datamesh dashboard. I have tried refreshing the source and target sheets several times, waited a half hour, refreshed again, etc and nothing seems to get them to update on…
-
Concatenating multiple Smartsheet fields into a single JIRA field
I have a need where I need 3 different Smartsheet form fields to be concatenated into a single JIRA field. For example I would want these 4 from My Smartsheet fields: * Description of Request * Expected results * Why is this info needed * What resources have you utilized To all be entered into the Description field in…
