- Bridge: Add Row module with empty cells
Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my question is that some row cell information will be blank from the source sheet going to the target sheet and thus my Get Row Cells Values come…
- Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
- Synchronise Team Member Availability between Resource Management and Smartsheet
I have team members with part time availability, as specified in their Resource Management profile. Smartsheet allows me to schedule tasks for the days they are not working - the sync to Resource Management then displays "100% allocated for 0 Days" - the 0 days is due to this being a non-workday for that team member.…
- Multiple Location in One Intake Sheet for one project
Hello All, We will have one project that will have multiple locations (that has other information such as num of people, city, country, name etc...). Since we have one intake sheet and as the new project comes in, new rows gets created. Our current solution is to create just a separate location sheet where folks can go and…
- DocuSign Integration: Logging in with alternative account
We're starting to use the DocuSign integrations since we've already been using it, and like the automation offered through Smartsheet. When I set up the DocuSign and created the two mappings we have for this project, I logged into my user account with DocuSign. However, I now realize that the envelopes are sending as…
- Smartsheet app authorization
Greetings, Looking for a little guidance. I would like to develop an app that sends data to a sheet through HTTP. I have used the Python SDK with a raw token in the past but now I need a more secure solution and figured creating a 3rd part app is the way to go. I am having trouble with the workflow. Whilst following the…
- Move Smartsheet attachments to OneDrive?
Has anyone ever had luck moving files from Smartsheet to OneDrive? I found another post that led me to believe it's possible via python, but I'm looking for something simpler. The solutions there didn't sound like they worked well or they were cumbersome to configure. I'd like to get attachments that are submitted via a…
- Can Smartsheet integration update the Harvest Forecast?
Good afternoon I'm hoping someone can assist me with some advice please? I have a client using Smartsheet for projects and Harvest for Time management. If we connect Smartsheet with Harvest, would the tasks created in a Smartsheet plan be able to update the Harvest Forecast? Looking for some advice from anyone with…
- Technical Support Horrible
We are new to Smartsheet and we are on an Enterprise plan. I had three interactions with support so far and all three have been horrible. First one was regarding this: Populating Contact List Dropdown — Smartsheet Community. I got more information from the community than the actual support case I opened online. The…
- Data Mesh execution frequency "Update Immediately"
I've created a Data Mesh config. I see the frequency options. I've tried 1-hour and does run. I have tried Immediately but nothing happens. What am I missing? I don't find any detailed documentation on the frequency setting.
