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.

Transfer of Sheets owned by an individual no longer with the company
Hi, In User Management, I would like to transfer Ownership of sheets, from an individual who left the company to another user. Will this transfer, need to be approved by the Sheet owner (who is no longer with the company?) How does this work? Thank you, Deepthi
Commercial real estate best practices
Hi Community, We are looking to connect with some fellow commercial real estate management (or similar) companies to share use cases and best practices. Anyone out there? Thanks in advance!
#Divide by zero error
I am having trouble with this error and need help with the formula 4 Columns (let's call them A,B, C, F) Formula used is: =SUM(Column B + Column C)/ Column A How do I make Column F equal Zero (0) when Column A is equal to Zero (0) Thanks, BM
Acceso a Informes con Acceso Incorrecto
Hola, he creado un único informe para que accedan a diferentes usuarios. Estará configurado el informe para que muestre las líneas en la que, la cuenta de usuario coincida con la cuenta de usuario que crea la línea o cuando coincida la cuenta de usuario con una columna con fórmula cuenta. Este informe funciona…
Creating a link that automates adding new cells into the sheet
On the current project I am working on, I am trying to use smartsheet to recreate an existing Microsoft Excel template that my company uses to collect data. At the bottom of the template, there is a cell that will create more cells at the bottom of the data set (ex. one region is working in 4 schools in quarter 1, but then…
Sheet size limits - workaround or alternative?
Hi all. We are tracking data with SS and constantly run into space limitations (on the 200K cell limit, I believe). Also, the size of the sheets are bogging down to the point of unusable for some. Anyone have an idea to work around this or is there a SS alternative that can handle a large sheet? Thanks in advance.
Automation with Update Request
Hi, I have automation working with multiple approvals and update requests. 1. An approval is submitted to 1st person 2. They deny and the workflow is set to either deny in total or deny with an update request. 3. The person who submitted then gets the update request but it doesn't say what needs to be updated just that it…
Dynamic View: Current User for Dashboard
I need to have current user view works on a dashboard report widget. May I know if it can be done by Dynamic View? I need to restrict user's view on the dashboard depending on who the user is and not sure if Dynamic View is a solution or not. Thank you!
Will changing a sheet name break the cell links?
I want to change a sheet name, but it is the source sheet to another sheet with cell links. Does anyone know if the links will break, if the source sheet name is changed? Thank you, Bill
Creating formula on past dates
We have created a sheet which has a start date and a due date. I would like to have the status column change to overdue once the due date is past the current date. If someone would be able to help me that would be greatly appreciated. Thank you Dave

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