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.

Stop Auto Formatting
I have a sheet with manually entered rows that are formatted gray to signify a day and if it's AM or PM. Users can then start filling in items below that row. When they enter their data, the sheet is using the auto-format function and also formatting it gray which is causing confusion. How do I stop smartsheet from…
Custom Welcome Screen not rendering properly
I have a dashboard with a lot of content that I wanted to set as the default welcome page. When I enable custom content and enter the dashboard URL I can see it in the preview, however when logging back into the system instead of the preview of the dashboard I get 3 windows rendered on top of each other. Each one is…
Ability to reorder list of sheets in left menu
When I am working on a sheet, every time I want to go to a different sheet I have to sit and study the list to find the one I want to go to. It is a waste of time and very frustrating. It would be SO helpful if I could put the list of sheets in the order I want them in. And have them stay in that order, unless I move one.
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
Delay between Sheet and Report
I have several rollups and am having trouble today where when something is updated on a sheet it is taking quite a while to update across to my rollup reports. I noticed this when I added a dropdown option and again when I received an email update about a new item. I could see the item in the sheet but not the rollup. I…
Setting Alerts At A Row Level Using A System Column
We are trying to set up the sheet so that when a particular task is checked off as "Received or Done" it sends an Alert to the correct team member. We have a systems column to allow us to set it up to be row specific to the task, but it isn't working. Please see the screenshot below. Thank you in advance for any help…
Report Builder not working
Is anyone else having trouble with their reports not working properly today? I can't get my report builder to recognize all the criteria I've selected. It is updating with incomplete criteria... when I change the criteria but it's just ignoring some conditions and not others. For example: column name "Status" = "closed"…
SmartSheet Slow or Down
After this weekend's maintenance, my SmartSheet access is incredibly slow. I've had several times this morning where I've save or refreshed small sheets and seen the 'spinning wheel' for well over 30 seconds. In some cases, I receive a dialog message indicating that "SmartSheet couldn't be reached - check your internet…
Email message sent out of comments not working?
Hello there, Just curious if anyone else is experiencing this? A few people in my organization have mentioned that the email notifications they are sending out of their comments are simply not going through. When I tested it myself, I found that it's not working for me either. I ask to see if it's an internal problem for…
Countif based on multiple criteria
I have two columns, assignee and status, that I am trying to use the Countif option on. I would like to count based on a specific assignee and specific statuses. If Assignee = A and (status = B or C), then count.

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags