-
WBS Numbering Error
I'm not sure if anyone will be able to help with this one, but I am running into an occasional problem that I don't quite understand. Essentially, I have a WBS numbering system running to give tasks an ID, and then using the ID to look up a letter equivalent from another sheet, and using that for the Item Label of each…
-
Smartsheet Build Version
How can I find the product build version for Smartsheet and other products? Thank you, Ron
-
COUNTIF formula help
This discussion was created from comments split from: Using COUNTIF in Sheet Summary.
-
Rolling 12 month column chart
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…
-
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".…
