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.

IFNUMBER formula, help!
Good morning all, I am trying to create a formula that essentially does a planned budget value - actual budget value to get the "budget variance" but only if there is a number in the actual budget field. Any suggestions? Right now it is only: =[Budget Planned]26 - [Budget Actual]26 But when we have no actual numbers in…
Syncing dates
Hello, I am new to SmartSheet I have set up a gantt view for a project and during the project we have had time slip. I would like to adjust the date for one of the items mid way through the project, then have all tasks after that to move on by the same amount of time. Is there an easy way to do this. Look forward to…
Alerts and Actions Badge Number
With the new UI change I am sorely missing the Alerts and Actions badge number that told me how many alerts and actions are attached to each sheet. What are the possibilities of including that number in the menu next to the menu item as in my attached screenshot?
Search or Filter to find entries based on the link instead of the value in a cell.
Hello, I'm relatively new to Smartsheet and have inherited a complex network of sheets that reference other sheets. Unfortunately there are a lot of entries where come of the cells are properly linked but others are not and it wold be very helpful to write a report or come up with a filter that can tell me which of these…
Unable to Export to PDF
I've seen that others are starting to report a similar issue on the community board. I was unable to export PDF's following the last upgrade of the system, and the same issue is back today. This has a real impact on the way I use Smartsheet, and is becoming a tytpical frustration. Smartsheet, can you comment on why this…
Forms
New to smartsheet and created a form to submit a survey; however, in the sheet page the headers are not my custom label which were created for the form. How do I view the actual label text on the sheet to correspond to the question I asked?
Printing not working?
Why can't I print my sheets? I'm getting to the Print setup, clicking "Print," and then a white screen. What's wrong?
Password Change Policy
Is there a way to set a password change policy? For example, I want people to change their passwords every 90 days. Can I set that to happen automatically?
Automatically add user to Group when added to user database
Hi all, We have a team account and keep track of our users (licensed and non-licensed) through the Smartsheet user database. We also have a group called "All Smartsheet Users." We use this group to share sheets that everyone needs to see as well as send emails to all Smartsheet users. Is there a way to automate adding a…
Employee Relations tracker
Does anyone have an HR employee relations tracker template that works for them?

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