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.

Pie Chart Data
Hi! I have built many pie charts in Smartsheet, but am stuck and tripped up on what is likely an easy fix…. I am trying to create a pie chart with the data below (these totals pull from other sheets, but I've also manually entered and still receive the same error), but I get an error message that the data cannot be…
How to get project overall delay in days in Smartsheet with multiple sub-parent rows
Hi While we use the Baselines on the task level to see the delays per task, is there a way to grab the overall project delay in days and also show it in the Dashboard? I'm using multiple sub-rows (up to three levels) to host tasks into different workstreams. Example: TOP ROW [Level] Parent Row1 [Level 2] Task 1 [Level 3]…
Daily Digest Automation email not showing sheet name
Daily Digest Automation email set up not showing sheet name , Bit strange if owner or admin is making changes then the name comes although if editor is making any changes automation email doesnt display sheet name Please see below Not sure If i am doing anything wrong, Any suggestions pls share Thanks
how to make all (not one by one) complete bar darker than not complete bar on report?
Does anyone know how to make all (not one by one) of the percent complete portion of the bar so it's darker than the % not complete bar? It's really confusing the way it pops up. I've tried to change several conditional formatting settings and no dice.
2FA Multifactor Authentication
Has Smartsheet added 2FA to Business Plans yet?
Activity log download is blank
This discussion was created from comments split from: View Activity Log Downnload.
Issue with Form Status Column Automatically Changing
Hi I've created a form to gather information from students requesting IT equipment. The form includes a status column with three options: "New Request," "In Progress," and "Resolved." The problem I'm facing is that whenever I update the status to "In Progress," it reverts back to "New" within a few minutes. Has anyone…
How do I create an automated email that includes all attachments at once, including a mapped doc?
Hi all, I'm trying to figure out the correct automation settings to have one email sent that will include a link to all attachments. I have set up a mapped document and automated email for when a row is added or changed. Currently, I'm receiving two emails - one for the new row with attachment links and an additional email…
Duplication of workspace
Hi, Smartsheet community, Can a workspace be duplicated? As shown below, I made a workspace for a dashboard with reports and sheets. I have to make the same one in multiple languages. It is easier for me to make some duplications and translate them into other languages than to start from scratch. That's why I'm asking for…
Dropdown filtered by criteria
I am currently using a sheet to generate all of our T & M tickets. It is built out of several columns to capture all the appropriate costs and then a document is generated off that row. Right now I am using one master sheet that carries all of the job pricing set up on DATA Shuttle to update the drop downs on the main…

Popular Tags

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags