Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
Need help with "IF" formula
I am unable to get the formula right for the following scenario: Column 1: Yes / No Column 2: Yes / No If Column 1 and/or Column 2 is blank, then "Not Completed" If Column 1 and Column 2 is Yes, then "Completed" If Column 1 is Yes, Column 2 is No, then "In Progress" If Column 1 is No, Column 2 is Yes, then "KIV"…
Double Brackets not working on Send Email?
I am attempting to use the 'Send Email' function and including fields in the email subject and body. I have attempted using the double handle bars but am not seeing the expected results. Any suggestions on what I may be missing?
New Dashboard Widgets
Hi ... in reviewing some of the youtube videos I noticed some different dashboard charts. How can we add or get access to other chart types than what is available in Smartsheets today? Thanks Jeff
Is there a way to export or print row numbers
Is there a way to export or print row numbers This would be so very helpful. Thank you
Report Builder Problems
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
Form Feed to one row?
Is it possible to have multiple forms for a SS populate to the same row if the same text is used in the primary column? I have a sequence of tasks that will be completed over multiple days. Each task has its own form. Or, will the form populate to a new row upon completion? If latter, I suppose the solution is to create a…
Editing Chart Widget
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
Attachments
Why do some of my attachments download and others open in a tab in my browser? Is there a way to save it with one or the other as the preference?
Pull child rows into report based on parent rows
Hello, would much appreciate it if anyone is able to help me out. I would like to be able to pull both parent and child rows of a sheet into a report based on a criteria which only exists in the parent row, is this possible? I'm not sure if there's just a setting I missed. Thanks, Sean

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

Categories

Popular Tags

Smartsheet Basics

Discussion List

Categories

Popular Tags