- 当下载前保持公式cel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
- Function to allow the import/export of multiple filters
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but currently if we want to set up filters each user has to create them from scratch. I would think this could be an easy feature…
- Import Data from Database
Good day, I am looking for a solution that will allow me to automatically populate a Process Owner column in Smartsheet from an Oracle table (for example). From what I have been able to find, the Live Data Connector is not capable of importing data from a Database to Smartsheet (It can go the other way, which in this case,…
- Forms: How to print/generate a PDF with field label and answers
I am creating a survey form, and the questions are quite long. There is a character limit for the column/field name, so I just use numbers (e.g. "question 1", "question 2") in the column/field name and put the actual questions in the field label. That seems to work for the form. However, I want to be able to print/generate…
- In 10,000ft/ResourceManagement - How can I get full reports in an automated way? (api or otherwise)
Is there a way to get a full report in an automated fashion? By full report, I mean when you go to rm.smartsheet.com/report, and click "Run Report" or "Request Underlying Data" and you get back a full csv. (format doesn't matter, csv or json formats are both fine). I would like to download the report automatically on a…
- Newline for Mapping
Hello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that I have been able to do this is by using =JOIN(COLLECT({Hotel Database Name Range},…
- Import from Monday.com
My team is switching from Monday.com to Smartsheet. We have 5+ workspaces and 50+ boards. What would be the best way to import everything? What would be the quickest way to import everything?
- Add data to Smartsheet by connecting to any API
I built a Smartsheet App called API Retriever that allows you to connect to any API, pull your data, and import it into your sheets. Check it out at https://www.apiretriever.com I'm happy to assist if you need any help creating a request. Let me know if you have any feedback or need any assistance!
- Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
- Automated Data Export
Hey All, I have a problem that I have been struggling to find an efficient solution for regarding how to routinely get form data out of smartsheets. I am hoping for ideas, advice, and/or secure tools that you all may know of to help with that. For context, below is my current issue/goal and what I think is the best…
