-
QuickBooks Integration
Does anyone have a process/method/workflow that allows Freelancers/vendors to enter time against projects/task within Smartsheet Link to an invoice function that has prepopulated cost fields as well as relevant math formulas Review/approve the above Integrate the invoice into QuickBooks to handle the transactions Insights…
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Getting attachment when attachment is added or changed to a row.
I dont know much of programming and I am not a developer. But I would really like to get attachments from a row in Smartsheet. Posibly automated, so when attachemnt is added or changed in a row, this triggers API. I was looking for a simpler way to do this, either directly with smartsheet, or with a third app like Zapier.…
-
Transfer of a workspace to another SMARTSHEET Business account
I have worked for a client to create a reporting workspace with multiples files and combined sheets. What is the way to transfer this worskpace and its property to my client who has a business Smartsheet account? Thanks in advance to share your advices and tips
-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…
-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…
-
API Access to Column Formulas
I have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a column formula is present via the API. Also, when a column formula is present, it is…
-
Hyperlink in Help Text
Hi everyone, I am creating a form in smartsheet and was hoping to create a hyperlink in the help text. It says here that we can include hyperlinks but every time I press right-click the option to do so doesn't seem to appear.
-
1006 error on an update to sheet with references
I am having trouble making an update to a sheet. I am confident my code works because I can make successful updates on a test sheet that I setup. I created the test sheet by doing a 'save as new' on the original. So all the fields are exactly the same. I think the issue has to do with formulas and references to other…
-
Python API - Getting Started
I'm barely getting started with Smarthsheet's Python API. I'm trying to get current user by using smartsheet_client.Users.get_current_user() but instead of getting a json response such as { "id": 48569348493401200, "email": "john.doe@smartsheet.com", "firstName": "John", "lastName": "Doe", "locale": "en_US", "timeZone":…