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.

Licensed User deleted what happens to the associated License?
When a Licensed User is deleted what happens to the associated License?
Workflow question
Here is the what I'm trying to accomplish..... I have a column for production area, which could be A, B, or C. I also have a column for supervisor. I want a workflow that sends an email to the supervisor, depending on which production area is selected. I'm not even sure I need a column for supervisor. Automation would…
Unable to Scroll While in a Formula
Hello, I am unable to scroll while editing a formula. For example, I am in line 648, and need to make it equal to line 45. If I simply hit =, and attempt to scroll out of view from 648 it gives me a #UNPARSEABLE error. I have been using SmartSheet for the better part of a decade, and never had this issue.
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…
How to count Checkmarks in a column
Is there any body that can help me with - how to setup " How to count Checkmarks in a column " I have a lt of columns which a need to have a total count of - In the top of the sheet or in the bottom. Thanks Søren Knudsen - Denmark
Formatting Sheets, workflow automation for hiding Columns
Team, we have smartsheet for 4-5 workstreams with usual PMO tracking columns. During our executive reviews I typically hide some Columns/format certain column widths/ wrap text etc. is there automation i can do for this, so that I can get to the view i am looking for with a single button click ( Instead of spending 5-10…
Weekly checks and scheduled tasks
Hi There, my support team has to check 600 - 800 technical setups on a weekly basis. They have to approach all systems physically and do certain routines. We want to use Smartsheet and its forms to easily document that process and generate reporting. We would populate a list with all relevant information and generate…
Permanently Deleted and still recover sheet ?
Hello community, I deleted a sheet. It no longer appears in "Deleted" since it is now 30 days since I deleted the file. Is there some way I can still get that sheet back ? Thanks and best,
Totaling up Days between Dates
Hello, If someone could assist me please that knows how. I am trying to get the total days calculated automatically between two dates. i.e 1st Sept 2019 to 15th Jan 2020 - How fo I get the total days calculated. Do let me know please. Thank you
Automation Notifications
I am struggling with the new Automation Notifications as I found the previous arrangement much easier to set up for simple alerts and notifications. I want to set up a daily notification that gives me only new comments that have been added to a sheet. At the moment I seem to have to get all the attachments, all the sheet…

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