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.

Can't see dropdown list in report but i can see in source sheet
Can't see dropdown list in report but i can see in source sheet
Automatically CC specific email address on a Form
We've created a Form attached to one of our sheets, but is there a way to automatically CC a generic email address into all responses? Or is the only option to create an Alert?
Looking for a formula to find max in a column based on condition in another
I have Four columns Task Number Flag1 Flag2 Task name 10001 TRUE TRUE A 10002 TRUE TRUE B 10003 TRUE TRUE C 10004 FALSE TRUE D 10005 TRUE TRUE E 10006 FALSE TRUE F 10007 FALSE FALSE G 10008 FALSE FALSE H I need to find the task name for the max task number that has FLAG1+FLAG2 as True. This indicates the last task…
Reports pulling data from a sheet
I there somewhere you can look to see who has a report pulling data from a sheet? I recently made a column type change in a sheet and this impacts a report if the column is selected. I know the Activity report within a sheet shows some items but not if the sheet is being used in a Report. Thanks, Peggy
Individual task lists for unlicensed users
Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports. I guess the project managers could create reports for individual resources, but the problem is that not all departments…
How to count grandchildren.
I'm trying to count how many grandchildren I have in a chart, how do I create the formulas for this? Note that I would be adding and removing rows and I need this counter to keep updating with rows inserted and removed. Example: * Parent (Grandchildren Count of 6)* Children (3)* Grandchildren * Grandchildren *…
Forms
Is there any way at this time to add a photo into the title area of a form? IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo?
Calculating Avg WD with Stipulations
I'm trying to calculate the average amount of workdays it takes for someone to respond using "Date Forwarded to DPD Command #1" to "Date request is returned from DPD Command #1" while having the "Command #1" column holding that specific command. I've played with it for a while, and can't seem to get it right. I currently…
Formulas For System Column
My sheet has a system column that shows the Modified Date of each row. Is there a way for me to pull the most recent date out to the sheet summary? I tried =MAX(Modified:Modified) but it says that it is an invalid column value.
Stacked Area Chart?
Hello, I would like to report the issues on my projects using a stacked area chart as per attached screenshot. Is there any way I can do this in Smartsheet? I am mainly talking about Dashboard functionality. Thank you!

Popular Tags

Trending in Smartsheet Basics

Column descriptions
Hello, Why i do not see Column Descriptions in the Report? thanks!
Why sheet viewed - No action taken - but in Activity Log list Formatting Applied, Why?
Hi this can be mis read as action taken. WHEN ONLY SHEET VIEWED. Unless embedded formatting is doing itself (wild guess). Need to understand where/why this line of log came from. Thanks, Jinwon
Non Licensed User - Editor Access - Update Columns
Hi - Has anyone experienced this? I have an unlicensed user shared to a sheet with a form with Editor access. I can see in Activity history she was able to change column properties for a column from Text to Date. Has anyone had this happen? I am wondering if she somehow edited the form?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags