Smartsheet Basics

Archives for July 2023

Conditional formatting in Gantt not working with dependencies
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
How to fill a column with list values from another spreadsheed or vice-versa?
i need to group values from one list into another spreadsheet so i can sum values
Configuring Predecessors in forward scheduling vs backward scheduling
I have a user who wants to schedule some projects in a forward-looking manner (top to bottom) and schedule other projects in a backward-looking manner (bottom to top). To explain to her how Predecessors would need to be configured in either scenario, I created the little example shown below. In the FORWARD section, the…
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
Recommendations for Mass Comms Content Calendar
I'm researching different templates within Smartsheets that would best fit the needs of a few internal teams for a mass content calendar to manage scheduling for external outreach among overlapping constituents. On a basic level, we can enter information on the regular sheet grid and flip to calendar view as needed,…
I have lost the ability to share a filter from a sheet I am the owner of. Any suggestions?
I have shared many other filters but some reason now I cannot. Any help would be appreciated.
Dashboard Metric Breaks on Update of DataShuttle
I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and says Data missing even though there is data in the field. Is there anyway around this or does Data Shuttle always break a Metric Cell?
Formatting report data coming from Sheet Summaries
Hi, I have created a Sheet Summary Report which pulls data from the Summary tab of multiple source sheets. Nothing easier, right?? But, I can't see any way to center-justify the data in the report (because normally it grabs the justification from the source sheet column). Is there a command somewhere I'm just not seeing?…
Dashbord
Hi, I am having trouble integrating the data from a form to a chart widget on a dashboard.
Copy Row Not Working
I'm on one of my sheets this morning and right-clicking the row and selecting Copy Row to another sheet. I select the sheet and hit OK. It's not going to the other sheet. I've tried 5 times and closed the browser and reopened it. Is anyone else unable to get Copy Row to another sheet to work today? Not the automation...the…

Trending in Smartsheet Basics

Form Submissions aren't appearing on the sheet!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
Why is my report suddenly blank?
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
Submissions
39 submissions isn't accurate because many of them were just tests. Currently have 3 submissions and would like for it to show 3, is that possible

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List