-
how to link comments in jira ticket to smarsheet via the connector?
i have a connection established between jira and smartsheet via the jira connector as recommended by smartsheet which enables the flow of information bi-directionally. i am looking for comments within a jira ticket to be visible in smartsheet via the jira connector. any idea on how to do that? i don't see any fields while…
-
Pivot app - and Count function
I've created a pivot table to summarize the number of task completions in a month. From this, I want to calculate the average monthly completions. The problem is, the table does not put a '0' in the months with no completions, so the averages are not calculated correctly (see below - 1 isn't the monthly average when only 1…
-
The Bridge
I'd appreciate hearing from individuals - not SS employees please - who have utilized the Bridge application. What about it made you use it? Did it do what you expected? If you had to make the decision again, would you still make the investment? Examples of how you use it would be a great plus. Thanks!
-
Data Mesh Unmatched & Unaffected
I'm having issues with my Data Mesh config seeing the data, but not acknowledging that it needs to move the rows over. 0 Total rows affected 66 Total rows unaffected 0 Total duplicates in Source 57 Total rows unmatched 0 Total formula cells skipped 0 Total nonexistent data fields mappings skipped 0 Total new rows added I…
-
Fillable PDF DocuSign automation
I am trying to automate the filling and routing of a fillable PDF template through Smartsheet using the generate document function and DocuSign. When setting up Generate Document Mapping, I can select PDF or E-SIGN. The PDF option allows me to setup a fillable PDF that pulls from the underlying sheet data but seemingly…
-
Outlook Calendar events publish Smartsheet?
Can I sync my Outlook calendar to Smartsheet? I manage sales training schedules, and some training are recurring ones. I use Outlook Calendar to schedule training and invite salespeople. I want to sync my Outlook calendar to Smartsheet and publish the Smartsheet on my team's event page.
-
Docusign Integration fields not consistently populating
When I send a generated e-sign document to myself, who is the administrator on the docusign account, all the Smartsheet mappings are working correctly (all the fields are transferred and displayed in the generated document). When I send the documents to anyone else, the fields are blank. I am at a loss!
-
Control Center Find/Replace to Edit Cross Sheet Reference?
Hello all, I was asked to delete a specific column in the CRAID Log template and all instances created through Control Center. In my Blueprint, I have a sheet that is used to store some meta data that feeds a larger 'master data' sheet. Unbeknownst to me, that column was referenced in a formula on the meta data sheet. Is…
-
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…
-
Formatting Currency in Calendar App
Is it possible to format currency in Calendar App? My source sheet has the data formatted for USD with no decimal places, but when the data pulls over to Calendar App it reverts to full number mode, which is very hard to read. I cannot seem to find any articles on this or way to fix it.
