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.

Using SUM function on a column that has IF formulas in the cells
Hoping someone can help me with this issue! Please see the attached screenshot. I'm having this issue on 4 columns but will use the "Visit Metric" column as an example. I want to SUM the values of all the cells in that column within a cell at the bottom of the sheet, =sum([Visit Metric]2:[Visit Metric]114). However, when I…
Cross Sheet Formulas For Children Rows
Hello. I´ve spent all day trying to look for how to do this, I found some info but wasn´t exactly what I needed, plus, I´m new using smartsheet. What I need is to bring info from another sheet, but only what is inside a children row. I have a budget sheet with several ancestor, parent and children rows; I need to use…
"Trace Dependents"
Hello Community, Excel has this "Trace Dependents" function which enables to know if (and where) a cell is refered in another cell formula. I can see that when a cell is further used in a smartsheet formula, the cell has tiny black/blue arrow. But I struggle to know the cell dependance. Any clue ? THanks
Moving Sheets
HI All I am tidying up our smartsheet account into workspaces as it was getting a bit messy. Is there a way to move sheets into a workspace without having to Save As and then reshare? Rs Abbie
how to see the collaborators ?
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
Resource View Filtered by Workspace, Folder or Sheet
I'm running into a challenge getting the Resource View to work. I've created a '2019 Roadmap Planning' sheet that contains all of the projects that my team will be working on this year. I've Assigned my team the the various projects and Allocated their time to those projects. When I choose the Resource View for this sheet…
Images not loading
Anybody else experiencing the problem the last couple days where images on rows/cards don't load? See screenshot. Where you see all those empty boxes within the cards, there are supposed to be unique images.
Auto Fill Formulas
I have a couple of formulas that need to be generated on each new row entry. Also I have an automated Create(Date) column. If the rows are deleted that do not contain the formulas in at least the last two empty rows, then the formula disappears. But if I add the formulas to the last two empty rows, then the Create(Date)…
Hyperlink to a network drive
Hi - I have a document stored on a shared network drive that I would like to be able to insert a hyperlink to. Is this possible with Smartsheet? The sheet appears to only accept web addresses as hyperlinks rather than file locations (for example: Z:\Documents\File.pdf). Uploading the document to a cloud storage provider…
Email Notifications
Assume i created a new sheet and added email ids of my resources into a column X in smart sheet where the column X is assigned as contact column. I have created a workflow where any changes to the rows on other columns in the SS, should trigger an email notification to the assigned email id of the updated row from the…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags