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…
Document View 💡
Hi Smartsheet Team, I hope you're doing well. I've been using Smartsheet extensively and have a technical suggestion that could significantly enhance the platform's capabilities. I'd like to propose the implementation of an advanced Document View feature, which would enable users to seamlessly interact with both tabular…
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.

Trending in Smartsheet Basics

Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…
Error message to
I am the owner of the sheet/workspace. I have given Admin Privilege to a few non-licensed users. One user was able to create a new report, and another user is getting this error message. Is this a Smartsheet issue?

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

Watch video

Smartsheet Basics

Discussion List