-
Can I submit multiple dates in a form for one event?
I am trying to build a social media content calendar. We have our posting schedule laid out at regular intervals prior to the event. For example, if an event takes place on March 17th then we would have a post going out on March 10th, a reminder going our the 16th, and another post the day of the event. I am using…
-
Portfolio Report exists & has current data but isn't showing in either Blueprint for me to edit??
We have 2 Blueprints set up in our Program & we have a Portfolio Report that currently pulls data from 3 sheets (it pulls the same 3 sheets from both Blueprints). We actually only want it to pull from 1 sheet in each Blueprint, so I went to Control Center & clicked through the pages until I got the Dynamic Report Scope…
-
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…
-
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…