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.

Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
When ZERO, Status change to YES
Hi, When the Balance column equal to 0, how the Status column auto change to YES ?
Deleted content in a row
How do I get back the data that was deleted in one specific row?
Smartsheet "Viewership" Access being denied!
Is anyone else experiencing a Smartsheet wide, all Workspace issue where unless your viewership is "Admin or Owner" you are unable to access sheets that you supposedly have access to? I've noticed the glitch "Fix" itself if I change someone's permissions from Viewer or editor to Admin, then put it back to their original…
Conditional Formatting not working
Hello, I've created conditional formatting rules that are not working. They work if I set the rule to "is not equal to" but when I set them to "is equal to" they stop working. The spreadsheet contains "#NO MATCH" cells automatically formatted from another sheet. I want the "#NO MATCH" cells to turn red (not the whole row).…
Switch from Office365 "work account" sign in to regular sign in
I currently use the Office365 sign in and would like to change to a regular email & password sign in. I found this discussion about switching to an Office365 sign in, but not one about switching from it. How do I do that?
Search and replace contacts
Hello everyone! I'm having some issues getting my head around the search & replace function: I have a standard project task with placeholder values for assignees (Ie "Project Manager" or "Consultant). In order to avoid manually entering every contact, I want to search and replace "Project Manager" with "John Doe".…
Templates and conditional formatting
I have created a Project Schedule Template that has all my conditional formatting included. However, when I import in a schedule from Microsoft Project the conditional formatting not longer exist? Obviously, I am doing something wrong? If you can lend any advice, it would be appreciated. Best Regards,
Default Card View
Does anyone know how to make the default view on Card View be on "Level 1"? Currently every time I log in to my sheet it is an "All Levels".
Multiple column count
Need help with a formula. It is to count total sites upgraded either to a interim or final result, but if the site has had an interim and a final it is only counted once. I have 2 columns with check boxes and need to count as 1 if a cell is checked in either column. If both cells in the 2 columns are checked also =1. so…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags