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.

Reports completely changed...?
Overnight, it appears that Reports have changed. My team can no longer edit previously created reports, even with Admin access! In addition, when creating a new report, I now have to choose between "row report" and "sheet summary report". Neither of them work correctly; none of the columns from the source sheet are pulling…
Not Counting Blank cells in Checkbox formula
Hi All, desperately need your help on this one. I've been searching the forums and tried this formula so many different ways and cannot get it to work. :( I have checkbox formula that is simple enough, I want it to check the box if we met the delivery date that was planned. So I'm comparing delivery date planned vs.…
Enable Confirmation Email: Add Asterisk
In order to continue the good work you've done on Forms UX, I suggest that when a user checks "Send me a copy of my responses," the form's subsequent "Email address" field label could be followed by a red asterisk, similar to all other required fields on the form. The client-side error-checking is nice with its red border…
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…
Dashboard and Metrics
I'm trying to figure out the best way to pull only proposed or active projects from our All PMO project lists and creating a dashboard. Based on the only active or proposed projects ....I need to pull data that shows the project type, approval status, departments, etc...
ISBLANK Formula
Hello,l Im using a simple formula to divide 2 cells, however the forula is showing its dividing by zero in every single cell so im attempting to use an ISBLANK formula so that the formula does not show. See the screenshot below. My forumula is originally.... =[Current Presale Total]8 / [Week in Presales]8 Then i tried...…
Automated Emails for Workflows - too many
I have set up the workflows (LOVE THEM) But... we are getting too many emails. One for the approval. then you get an email stating what you just approved. This in a world of too many emails. How can we stop the extra email notification? I unchecked the box on the personal settings - but all that did was not give ANY email…
Standard Milestone Names
I am creating a project template for my department to use for all projects. I have created drop menus to limit certain column entries to a controlled list of choices. I would like to do something similar to control how the user names a milestone. Is there a way to have a list of standard milestone names for the user to…

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