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.

Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
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?

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Controlling Asset Permission Levels
I have a feeling the answer is NO, but wanted to confirm. We are considering upgrading our Enterprise plan, but need to consider the significant price increase if we upgrade, so we are looking to cost structure variations based on what our users are doing in Smartsheet. We want to control the assets being shared not only…
Is there a way to start a task as soon as possible with a FF dependency?
What I'm looking to do is create a finish-to-finish dependency where the end date is extended but not the duration for a given task. This way a task can start immediatly but it may finish later than the duration. This way the duration of the task can outgrow the FF dependency but never be less than the FF dependency end…

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