Smartsheet Basics

Archives for May 2018

Setting up a Program with multiple project
Hello! I am fairly new to SmartSheet and am looking for some advice on how to set up a program management sheet. In short, I have multiple sites which have various tasks I need to track of. I would like to organize by site and task or at least be able to pull a report (or look at a dashboard) that will indicate what is…
Product Submission Warrant form
Anyone using SS for PSW's? I;m thinking it would be a great way to have suppliers submit their Inspection reports, PPAP reporst etc. Any thoughts?
Error in Uploading Files to Smartsheet from China
Hi We have some members of our China Office that are using Smartsheet. They are currently having issues being able to upload files. I know that in North America it is preferable to use Google Chrome for Smartsheet because there are less errors. Is there an equivalent Browser like Google Chrome for China? Is there something…
COUNTIFS Formula
Hello Community, I am encountering difficulty in using COUNTIFS formula to count the items with active dates within the quarter of the year. I tried the below formula in Excel spreadsheet and it worked well. However, the formula doesn't work in Smartsheet. Formula in Excel spreadsheet: =COUNTIF(D1:D344, "<10/1/2016")…
locking a single cell
Hi, I would like to know if the latest features support locking a cell? Thank you.
Error Message
Error message when trying to connect to Smartsheets remotely (this has only started happening the last few days). See the screen shots below. As smartsheets is in the cloud it does not seem correct that I should not be able to get to it via remote connection. I have using my Pernod laptop. First Message, says contact the…
Stop Smartsheets.com from sorting spreadsheet alphabetically by the first column
How can I stop Smartsheets.com from sorting my online spreadsheet alphabetically by the first column? I have pasted this spreadsheet directly from Excel 2016 and I want it to stay sorted in the original order; I don't want the spreadsheet to be sorted by alphabetically by the first column within Smartsheets.com. How can I…
Tracking re-occuring assigned projects
For example if on a team I have 15 projects that are on going Assignment 1, 2, 3, 4 etc I want to assign primary, secondary , tertiary Then I want to have each person list how much time they spend a month in each of these roles Is there a template for this in smartsheet including formulas for adding hours per month per…
Alerts & Notifications Settings
I am trying to see if my Smartsheet System Admin has restricted my ability to allow anyone to receive notifications. Does anyone know how I can check this setting? Thanks.
When you click "Done", any future reminders should stop emailing us
smartsheet says the software is not set up for this. I think it used to work perfectly a few years ago. anyone have any thoughts or workarounds?

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

Trending in Smartsheet Basics

Linked Dropdown Columns
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?

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

Watch video<

Smartsheet Basics

Discussion List