Product questions?
Sign in and ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Predict or set which row a form writes to
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…
Bulk Deleting all outstanding update requests
Hello, I have a few hundred update request on a Smartsheet that simply need to be deleted out. I can go one-by-one and delete these out, but I was hoping there was a way to bulk delete them out. Is there a way to do this?
Is there a way to format groups in a report?
I have created a report that pulls every task with my name on it, and they're grouped by sheet name. Is it possible to change the group header where I can add notes, change cell color etc? If not, is there a way I can create a new sheet that pulls the same tasks?
Is anyone else getting this message
I repeatedly keep getting this message "sorry we're having trouble reaching smartsheet right now. Please check for any known issues at status.smartsheet.com or contact us at www.smartsheet.com/gethelp for help.". It happens on different sheets and doing different processes so I can't pin point it to one thing. I am not…
Automated Message from Triggering User
I set up several automations that result in an email being sent to a person after a form has been filled out by a particular user. That particular user should be the "triggering user" meaning when the email is sent, it should appear as though it comes from the person who filled out the form. Instead, though, the message…
How can I view the total list of specific fields from the dropdown.
Currently, the dropdown appears to be limited and does indicate the number of fields that are not being displayed. How can I expand the view to see all of the specific fields. See screenshot.
Chart Widget shortcut to Filtered Sheet
Dashboards charts tend to reference a subset of a sheet. It's logical to want to drill down to that specific data subset when trying to find more information on a graphic. Is there a way to make widget behavior->open data source also apply a pre existing sheet filter?
Is there a way to send an alert EVERY 48 hours (recurring alerts)?
Hello, I already know how to set up a workflow so that it alerts someone if a change was not made in 48-hours. However, that is a one-time deal. Once it reaches 48 hours and the email alert is sent, the workflow is done. But, if the user still did not make changes 48 hours later, I want another email sent again. And so on.…
NEED HELP WITH INDEX/MATCH! Tried EVERYTHING!
I am really struggling with getting the INDEX formula to work, and I'am not sure where the hiccup is. I have a sheet "Property Metadata" that I would like to autofill the columns based off of the "Prject ID" cell. When I enter the "Project ID" in sheet "Property Metadata", I would like it to reference the "Project ID"…
Approval work flow not working for one approver.
I have an approval workflow that goes to two different people based on department. It works correctly for one person but the other person does not have the option to approve/decline only to save. I've attached a copy of the screen they see when they open the request from their email as well as a side-by-side of both…

Trending in Smartsheet Basics

#INVALID DATA TYPE (Simple True False Logic)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
Parent and child sorting issues
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Displaying a Deck instead of the GSlides on Dashboard
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…

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

Watch video

Smartsheet Basics

Categories

Popular Tags

Smartsheet Basics

Discussion List

Categories

Popular Tags