-
Forms: Best practice to reduce columns when using forms with logic
I am setting up an IT ticketing system to replace our aging system. I have a ticketing form set up using logic. In short its --> Issue or Request --> Request type select --> Subtype1 --> Subtype 2 --? etc... --> Issue type select etc... all the way down... As the user makes selections, more options are presented. The…
-
Workaround for PowerBI Navigator record limit
Problem statement: When looking to utilise PowerBI via the Live Data Connector I was unable to find the sheets I wanted to connect. Cause: The PowerBI Navigator will return a maximum of 10,000 records from a given source. Workaround: I've managed to work around this by setting up a second DSN connection for the Live Data…
-
Document Builder - Adobe Calculated Fields
Hello community, I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script: var today = new Date(); event.value = util.printd("m/d/yyyy",…
-
Transfer ownership of integrations/connectors
I have a few integrations I have created using the Microsoft Dynamics, Salesforce and Jira connectors and I wish to transfer them to another user. We are centralizing the support of Smartsheet support and I need another user to take over the support and ownership of the connectors. Is there any way to do it or do they need…
-
Dynamic View Detail Panel not displaying selected fields
I have a Dynamic View built from a report with 59 columns. The original sheet has 130 columns. I set up the Detail Panel to display 19 of those columns. I do not have any conditional formatting set up and none of the fields are hidden or required. When I click into the Detail Panel, it is not displaying some of the columns…
-
Dynamic View: Un-editable Fields
I am having an issue with Dynamic View treating (random) editable fields as "Read Only." In this instance, Dynamic View is treating a Date Field as if it were a "Read Only." In the first screen shot, you will see that the "Date Resolved" field is not marked as "Read Only" in the design mode, however, when you open the View…
-
Has anyone integrated smartsheets and Microsoft Powerapps?
I am attempting to use smartsheets as a data source in powerapps and then transfer the data from powerapps into a new row in smartsheets and was wondering if anyone has been able to extract data from smartsheets into powerapps and also transfer data back to smartsheets. There is little documentation on the formatting of…
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
Smartsheet and Google Workspace Users Rejoice!
If you are a Google Workspace user, you now have an additional, powerful tool at your disposal to enhance you Smartsheet solution. Google has announced that its no-code app building platform, Appsheet, is now INCLUDED with Google Workspace! This a big deal especially for Smartsheet users! That's because you can connect…
-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…
