-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Row Report - Displayed Sheet Names Do Not Update
I have several (OK, 10+) Smartsheets in a workspace and have put together a row report which filters and only displays the open tasks for each Smartsheet based on the column information. Simple enough. My problem is that will update the individual Smartsheet names to allow for easier sorting, however this takes an…
-
Set an End Date for Project and use predeceasors to work backwards
I have Parent and Child rows set up in my sheet - Parent is the project and Child rows are the steps. I want to set the expected "Completion date" in the final child row and automatically (with set durations) work backwards to determine the expected "Start and Completion date" for the child rows that need to happen prior.…
-
Count the # of times a person was assigned a specific request type task and in what month
Hello! I need help applying a formula to reflect the following. Background: We have two sheets: Observe Request - Completed Client Insights Client Insights Tracker What we need: Apply formula in the client insights tracker that pulls from the observe request - completed client insights file that shows the count (#) of…
-
URL Query report options
Create query endpoints for reports so a link can auto filter a sheet when the URL is clicked to do certain things. This would make it much easier to manage reports for weekly/monthly/quarterly, and many other things. In my use case, this would simplify how many separate reports are needed. Below is an example of what could…
-
Automation workflows that were working are no longer emailing gmail and msn addresses
Our existing workflows that trigger automated email alerts have started failing. It started in the last day and only affects gmail and msn addresses from a contact column. The failure message is, "Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow".…
-
Quick Tips and a list of Frequently Asked Questions
Quick Tips for engaging in the Community 🔎 Search before you post: Before you create a new post, search to see if your question is already out there. 💬 Be descriptive: Include screen shots and as many details as you can when asking questions or providing an answer (without exposing sensitive data). The more details you…
-
Outlook Calendar integration showing time of event and not just the day,
Smartsheet is great for planning events but when that date is added to an Outlook calendar, it shows up as a day event and not the specific time of the event. Not only does it look like a day event but the inability to change the calendar to the appropriate time of the event is creating more work. It would be great if this…
-
Jira Connector Error - Illegal Character
Hello, We are working on a bi-directional sync via Jira Connector and continue to receive this error when we try to push new tickets into Jira from our Smartsheet (which is successfully receiving Jira updates and updating existing tickets) - JIRA rest client exception occurred while syncing issue.…
-
Odd behavior with Index(Match
Using a basic Index(Match on 1 criteria to cross reference 2 sheets. I've checked multiple times that 1) the cells pulling in are actual numbers (no formulas), and 2) there is a MATCH to pull in. Here is the formula - appreciate help on what I'm missing =INDEX({Equipment Leadtime - MPTs MVA Limit}, MATCH([MPT…
