-
Progress charts
Hi, Can some one help me how to build a progress chart using smart sheet? Similar to the one shown below Once level is fine instead of shown 3 levels, would like to show particular day GREEN/RED based on ‘pending requests’ shown in the attached table Any help will be much appreciated Thanks, Basha
-
I'm creating a form that will require hundreds of entries, how do I make this easy for the end user?
I'm recreating a form that was once a multi-tab excel spreadsheet. This link will be hosted on our webpage and will require users to list up to hundreds of names. What is the most efficient way for them to do this? Should I have them attach an Excel file to the form? I want to be able to upload the names to a potential…
-
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…
