-
Troubleshooting Data Shuttle
I am having issues with Data Shuttle adding rows at the bottom. It seems to be skipping 20+ rows in Smartsheet when my data source doesn't have those blank rows. I did add a filter to filter out blank rows. Any suggestions?
-
Need guidance with structuring a Sheet fir UAT and launch milestones with tiered stakeholder roles
Hello Smartsheet Community, I'm in the process of developing a sheet with the intention to generate a smartsheet calendar view; The goal is to list leaders, team members, relevant milestones, dates and their specific levels of involvement (inform, communicate, etc). Currently, my setup requires adding extra rows for each…
-
Parent Row showing on multiple rows in a report
Hi, I'm currently using a sheet with information about different projects and need to show a Parent Row on all the other different "statuses" assigned to different Subtasks of that same project, I already have a formula to show the Parent based on their children, but I would appreciate any help on this issue. Attached…
-
How do I create a search tool within a sheet and referencing another sheet?
Hello everybody, I am a new user of SmartSheet and I was recently assigned a project of building a search tool within a data sheet. I got a way of doing it on Excel but I would prefer to build something similar on SmartSheet. Does anybody have any idea or how can I get to do this? Basically I have a master sheet like this…
-
Looking for a simple way to track account balance to make sure it stays above 0
I'm tyring to find a template or example for a really simple sheet that tracks money in and out to make sure that we don't go below 0. A fixed sum gets added at the beginning of each month and then each project has a 'number of items' x 'item cost' amount of expenditure at a given date and that's it. I had a version in…
-
How can I change the WBS phase number for my WBS by phase?
Hello, I am trying to figure out how to change the WBS phase number for specific tasks in my project. For some reason a group of about 15 tasks is assigned to phase 1 in my WBS, but they should be phase 10. The WBS number is showing 10.1, 10.2, 10.3, 10.4 and so on, but the phases for these are locked in. How can I assign…
-
Form Questions are not aligned with sheet columns
Hi All, I created a sheet from a template with multiple columns that record the responses from a form. I changed the questions in the form I created from the sheet, but not the columns in the sheet. I collected responses, but I'm now not sure which column correlates to the form questions that I had changed. Is there any…
-
Cells auto adjust based on forms submission
If a column has the wrap feature activated, it currently will not wrap if the data is submitted through a form. The only way around this is to refresh the Smartsheet. We currently use the form feature to have users submit information to our command center (control room) so we can see and address issues in real time. The…
-
RFI Request for Information Template - can not find
I found the RFI Request for Information Template that I loved on Google so I signed up for a Smart Sheet account. Im logged in and search for RFI Request for Information Template- the search result is a "Status View Smart Sheet" not a RFI Template. See screen shot. Here is a link to reference page to RFI Request for…
-
COUNTIF with multi select dropdown
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit. In a difference sheet, I'm trying to count the total responses. So Grapes should be…
