-
keeping information current / between two sheets
Hi, I have several worksheets, one being the master. I have figured out how to "copy" a line from one to the other, but when that line changes, it does not update the other sheet. How do I ensure the two stay in sync? as an example - in the secondary sheet, the line changes from planned to completed, but that change is not…
-
DocuSign: Creating a Dynamic File Name
I am using the document generation with DocuSign capability. All but one of my fields are successfully populated in the generation and passed on to file that ends up in DocuSign. However, I am having trouble with carrying over the generated file name from Smartsheet to DocuSign. DocuSign seems to ignore the file name in…
-
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…
-
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…
