-
Planview to Smartsheet Data Integration
Hello, I have a Planview data that I will be needing to directly and automatically populate in Smartsheets grid. Is there a way to connect these data apart from the option of having to export excel from Planview then import excel to Smartsheet? Thank you for helping!
-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
Nonprofit looking for assistance expanding template set
Hello All, I'm in Operations at a nonprofit. I am hoping for assistance in building out the Template Set for Objective and Key Results (OKR) Tracker. The template set is built for 5 objective. I need it built out for 12 and I am running into difficulty connecting cells/sheets and formatting. I have a blank copy. If someone…
-
Python SDK - 'Field "null" was of unexpected type' when creating a webhook
I'm trying to create a webhook using the smartsheet-python-sdk (2.105.1): webhook = Smartsheet.models.webhook.Webhook( props={ "name": "[redacted]", "callbackUrl": "[redacted]", "scope": "sheet", "scopeObjectId":"[redacted]" "events": ["[*.*]"], "version": 1 } ) print(webhooks.create_webhook(webhook)) I'm getting the…
-
Seeking consultants
We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking expressions of interest for Smartsheets consultancy services and ongoing support.
-
Can I start multiple workflow in the same time and using same form?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work.…
-
how can add multiple approval request in the same row and cell using workflow?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i can add multiple items in one time to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work. Thanks.
-
Manual Workflow Trigger for Time Base Automations
Hello all, I was setting up a Workflow to trigger based on a condition at a certain time of day. It did not work, which is fine it was a test, but now in order to run that same test again, I have to move the trigger forward an hour and wait for it to reach that time. (Function is to clear a checkbox daily) Since I am…
-
Building A Test Package In SQL Dev That Writes To A Smartsheet
Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table. How do I go about creating a package that does this? I have never built a…
-
How do you access user data once authentication is made in OAuth flow?
context: I integrated a Node.js Smartsheet Oauth flow into my Django app by having the login button in django direct the user to the /auth url on the Node server. Once the flow is done and user logs in through Smartsheet, the redirect URL from the Smartsheet dev tools takes the user back to the Django website. Objective: I…