-
SCC provisioned projects connected and linked, but Summary sheet not showing actual linked cell data
I provisioned a large number of projects and everything seemingly went well. As i start to look around more im finding some oddities. One in particular I don't understand at all... The project provisioned successfully. The data is all there without errors. The summary sheet rollup shows the project with successful (blue)…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
SCC: Dynamic Report Scope - Shows grouping headers but no rows of data?
One of my Dynamic Report Scopes built in SCC is not showing any data. It displays the grouping headers, and if i change filters the grouping headers change as if the data has changed. But the actual rows of data are not being displayed. There is also a warning at top saying: Not finding the rows you're looking for? Try…
-
Unable to Perform a Global Update on a Sheet Summary Field
I am trying to replace a formula in a Sheet Summary Field and it doesn't do anything regardless of what I choose. After adding Advanced Criteria [ROW] Is Profile Data doesn't seem to do anything. It appears I am missing something or it is not working?
-
Map Opportunity Notes to a Column in Smartsheet
Hello, I am new to Smartsheets, In our current project we are working on Integrating Smartsheet data to salesforce Opportunity Object using Smartsheet connector Tool. We were able to map al the columns, but need to map a column in my smartsheeet to a related Standard Notes on Opportunity Record. Please let me know if it is…
-
Leading Zeros in Data Shuttle
Hi - I'm trying to set up a way for end users to do bulk adds to our user list (vs one at a time via a form) and I have all the fields mapped in data shuttle and am getting results, except the leading zeros are being stripped away. See examples below. Since it is a data merge I can't see how I would add the ' before the…
-
Jira Connector Stale Data
Hi, We primarily work from Jira but tend to use smartsheet for easier bulk changes and workload overview. The problem we frequently run into is that the smartsheet side tends to have stale information that may or not resolve itself when a ticket is updated. Our most recent examples are: 1) Issues that fall out of the scope…
-
Calendar App - Does it function like report and can a filtered view be published?
Multi-part question here... Can the Calendar App source data from multiple sheets? If so, does it have a "current user" filter option like reports to show all tasks assigned to the current user in a calendar format? If so, can that filtered calendar be published to google? If so, and a date for a task is changed at the…
-
How to get Data Shuttle to pull all information from the csv file
When I upload my CSV file into my storage sheet, it does not bring all the information over to my master sheet.
-
Salesforce/Smartsheet Connector: Salesforce filter with multi value
Hi, Is it possible to have multiple values in the salesforce filter section of the connectors as below? I tested and it didn't seem to work. Is there any workaround for this? Thanks