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.

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
Can a System Administrator view all sheets in our account?
We are considering moving an existing survey over to Smartsheet. In this survey, leaders of our company share specific comments about their direct reports. Would our System Administrator in IT be able to see the data in this sheet by default? If that is the case we would not be able to make this change.

Popular Tags

Trending in Smartsheet Basics

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags