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.

How to create an automated update request for assigned tasks based on job roll
Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search. I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be…
Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Moved: COUNTIF reference not working
This discussion has been moved.
Workspace Panel Auto-Opening
I know this topic has been addressed previously and was resolved but is now happening again. Is there a way to disable or remove the workspace panel from auto-opening each time you open a sheet? It's extremely frustrating!
Workspace Panel
This has just started happening in our company and is quite annoying for a bunch of our employees. Is there a way to stop it from opening every time our employees open a dashboard, sheet or report? It is just extra annoying clicks all day long! Thanks in advance
Trying to use average formula of the DURATION with multiple criterias in the same sheet
I want to check a Lead time AVR for on the Duration Collum for only specific STATUS :Pending Marsh, Pending Lockton, Pending Lockton and Marsh and Pending LL I tried below formulas but are not working at all. =AVERAGEIF([Status]:[Status], OR([Status]@row = "Pending LL", [Status]@row = "Pending Lockton and Marsh",…
Automation Limits
Hi, has anyone found a way around sending automations that are over 2,000-character limit? We aren't prepared to purchase the additional add ons, we have this process yearly but it's just a notice to send. Anyone have a way, or do you know if I can attach a file using automation?
Enhancement Request for Smartsheet Proofing Features
Hello Smartsheet Development Team, We would like to request enhancements to the Smartsheet Proofing features to better facilitate the processing of RFIs and Submittals in the construction industry. Currently, due to limitations and licensing requirements, we have paused using this solution and reverted to manual data entry…
How to change my Primary Email Adress
If you need to update your primary email address, reach out to a System Admin on your Smartsheet plan. Only System Admins have the ability to modify a user’s primary email address. Question - how do I know who is my System Admin?
Equipment inventory log
I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigned to someone, and another to archive any movement. I have a form that they fill out when assigning the equipment out which…

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?
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…
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags