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.

Gantt chart timeline settings
I have admin access and have set the Gantt settings on a particular sheet to Primary heading: Months Secondary heading:Weeks I have shared the sheet with another user and given them Editor - can share permissions but they are seeing a different view on the Gantt chart. Why is that? What do I need to do for them to see the…
Sum values from column based on criteria
Hello, I am trying to sum values from a reference sheet based on common criteria. However I am running into either "#INCORRECT ARGUMENT SET" or values that are not the exact sum as expected. My idea is to SUM the values from the attached request sheet (column 12), into the corresponding rows (column SUM) in the attached…
Use SmartSheet for Resource Planning
Hey There, I am new to smart sheet :) I want to use SmartSheet to... * ... get an overview over all projects that are going on in the team. * ... get an overview about the project status. * ... see how many resources are available (aka how many manhours are available). So far we using simple Excel sheets and oviously I…
Countifs with Unique values
Hi, I have a sheet within parent/child rows, and need to count the number of unique contacts within each of the children rows of each parent. I have a vendor column that has a parent row and children row (only the children rows list the vendor contacts). I need to count the number of unique vendor contacts, within a…
Primary column not returning values in Report
I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interestingly, when I print the report to pdf, I see the project name values.
Multiple Upload Fields
Hi, I need to have 2 upload fields on my smartsheet (1 for a logo and the other for photos). Can you please assist in helping me get this built. - Kyra
Transfer Sheet and Report Ownership While Keeping in Same Folders
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
Keep Workspace/Folder Structure when Bulk Transferring Sheet Owner
How can I get sheets to remain in the workspace/folder when bulk transferring a user's sheets to someone else?
Changing colors and company logo
Hello everybody, I'm a licensed user and want to change the color of the sheets and the company logo. When I click in the account the "Personal colors and logo.."button and pop up window opens and want to upgrade me. As I don't need this, I close the window and I am back to the original screen. Can anybody help? Thanks,…
% Complete Calculation
Is there a way to exclude tasks/rows from the % Complete Calculation?

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?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags