-
SUMIFS With Multiple Criteria
Good day Smartsheet team, I'm a hardcore Excel user attempting to migrate my skills over to Smartsheet and I'm getting lost in the translation. Attempting to set up a formula to pull specific data into a sheet using SUMIFS. Here's my formula: =SUMIFS({GLData Range 1}, {GLData Range 3}, MONTH(@cell ) = 4, {GLData Range 4},…
-
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…
-
Unable to open smartsheet backups
I have a few workspaces scheduled for recurring weekly backup. These backup downloads used to work perfectly , until we started to notice a change in how these downloads were available to us. I understand that I need to use the link from the "Smartsheet Backup Complete" and follow the procedures set. " Click here to…
-
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…
