-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…
-
Revoke Sharing Access after certain number of days
Hi. Is there a way to automatically revoke sheet sharing access after a certain number of days (e.g. after 60 days)? We''d like to give a third party access to our file but only within a limited number of days but we want it automatically.
-
Sight - sharing via email a PDF version
Is there a way to share the sight the same way we are able to share a regular sheet? sending it via email in PDF format at a certain frequency rate (monthly, weekly etc)? Thank you Luiz
-
Only Move Rows with specific column value (API / cURL)
I'm a little new to the Smartsheet developer tools and I'm trying to move rows with "completed" status. I was able to move rows to another sheet if I specify the Row ID but is there a way to do this without specifying row ID? Basically, I'm trying to only move rows IF they have "Complete" under the "Status" column. Thanks.
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
Integrating with SharePoint
I would like some suggestions for integration with SharePoint. What are the best practices and ways to share information. Will information shared be actively updated or is it best to generate reports to be shared as static images that update at certain intervals? All suggestions would be much appreciated.
-
Exporting History Data
I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or…
-
Integration with Infusionsoft
I see there is an integration for Salesforce, but is there currently or plans in the future to build an integration with Infusionsoft? Infusionsoft is a tool that all small businesses are or should be using to automate their sales and marketing. It would make sense that smartsheet would integrate with Infusionsoft.
-
Cell Linking/Formulas in Reports
Has anyone worked on implementing cell linking from reports to worksheets and customizing reports? I dont see much in having reports if you cannot customize certain things after running, such as: formulas for totals in reports, conditional highlighting in reports, adding custom columns in reports. Also, without a cell…
-
API 2.0 formula
Has anyone had any experience of trying to add a formula through the 2.0 API? If so could you please let me know what the JSON syntax should be?
