Hello, I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and…
Can bridge be used to communicate with quickbooks? Specifically, can Bridge export purchase orders, and budget estimates to quickbooks?
We have a template set that worked fine in Control Center until last week. We made many significant changes to the template set to streamline it. These changes coincide with the recent Smartsheet reports updates. When we try to provision a new workspace using the updated template set we get "Failed to copy folder to temp…
I found it in Control Center under Customize Profile Data? How can we make the best use of it?
Hi, Is it possible to fill/generate a PDF template using the Smartsheet API in Python? Alternatively, has anyone tried to use Python module/s (fitz, PyMuPDF, etc.) to fill (not read) PDF template? Thanks!
I'm needing a way to send only one email to attendees who attended multiple workshops, listing each workshop they attended. Right now I can only send one email per workshop to attendees. I'm using the Excel file exported from my Smartsheet registration sheet with a Word document to be emailed through Outlook. Would anyone…
I thought this was an option, but I can't seem to get it to work. I want to be able to add a comment into the row of the Smartsheet that was just modified by the input row feature in Flow. I took some screenshots of the flow to help, I think I'm missing some part in order to get this to work.
Hi community - we are using the Calendar App and need to display our events by Week for our use case. However - Week 1 is automatically displayed as the label for the week beginning Monday January 4th (Monday's are our week start day of the week). However this is not our Week 1. Is there anywhere to go set the week number…
I have a fillable PDF I am using with Document Builder. Is there a way to include the cell color from my smartsheet into the PDF? It is filling in the text fine, but not the cell color. Thanks! Joanna
Can Data Uploader be used to fill in 4-5 columns of data from a Legend Table, where the Unique Identifier Column could be duplicated in data set?
I've created a very simple workflow - copying data from one sheet to another when a row is added (just getting started). And I finally got the darn thing working - Yay!! BUT: I just got this error - because the date in the source sheet is blank. How do I set it so that if that date is blank (or any field, for that matter),…
We have the Data Mesh add on. I'd love to be able to "copy and add" (automatically add new rows from one sheet to another) based on certain criteria. In this way, everything added to the new sheet is filtered by what I want. In this way I can manage all my requests in one sheet, and have it copy to other sheets by client,…
In Data Shuttle, I'm running into a "Please select a Target before configuring the Mapping" error on the Mapping page, but I've already selected a Target sheet. Mapping: Target: I ran into the error when creating a new workflow, so I went to an existing workflow to see if I'd run into any similar issues. I Next-ed through…
Help shape the future of Smartsheet. Share your ideas and feature requests.