Smartsheet Basics

Archives for October 2021

Column not found error in OOTB backlog planer and report
Hi, I have deployed an Agile project - predefined set of smartsheets: https://app.smartsheet.com/b/publish?EQBCT=dc9947a9e8f34d1ca6ad207b18505e59 Dashboard - Backlog and Sprints Report - In Progress Tasks Sheet - Backlog & Sprint Planner However, when there's an error in the columns available in the report showing that I'm…
Calculating Median value across two sheets
Hello! I am working with two sheets. One sheet contains all active requests and the other contains all fully completed requests. Both sheets contain a column for "# days to complete" Task A and also the Year + Quarter that that task was completed. I'd like to find the median days to complete Task A per quarter. Any…
Best Practice for Ordering Rows?
This is pretty basic but I thought there might be a better way than how I'm going about it. We want to list some testing tasks (each task is on its own row) that need to be performed in a certain order, but we don't have dates associated with them so I can't sort them chronologically. We need to keep them in the order in…
Data on submission form does not post to my tracking sheet
I created a form to intake data into a tracking sheet. It had been working but it no longer adds the data to the tracking sheet. Not sure what is going on. Can anyone help?
Unique Contact Lists
I am setting up the downloaded “Template Set – Sales Pipeline Tracking”. In “Sheet – Sales Pipeline,” the column heading “Contact Name” uses the Column Type “Contact List,” as does the “Sales Rep” column. Our Sales Reps are internal employees. And the Contact Names are external customer contact. How can I assign these each…
Reports user-friendliness
Hello, A little bit of context: I have a central Sheet displaying data and gathering inputs to & from multiple stakeholders via individual reports. This sheet holds a number of workflows, is fed by several datameshes, etc. In theory I don't want users to be able to see data from other users. To do this here is the option I…
How can I pull data from a multi select drop down column?
I created a multi select drop down column for my team to select project types. Now I need to pull the number of each project type and summarize it into a graph or chart. How can I do that?
How to retake a failed quiz in Smartsheet Foundations Path ???
coming back to the topic and selecting quiz, you get you fail the quiz, but there is no way to retake it ... anyone knows how to do this - retake the quiz ?
Manipulating Smartsheet
Hi Group New to using Smartsheet I have the following questions Question 1 When creating schedules, is it possible to have Smartsheet give days or weeks from planned start date? Example: Start date: October 11 Planned Week Duration: 2 Weeks Resulting Date: October 25th Question 2 Some type of revision control Trying to…
Determining SmartSheet access method email+password vs Microsoft (Azure AD)
Is there a way to show what method users are using to log in? I want to ensure all our internal users are using Microsoft (Azure AD) as the login method rather than email+password and it would be useful to know who is using which method. If I shut down email and password access I believe that will affect external users, is…

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

How can I view the Gantt chart in days?
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
User Types for Update Requests/Forms
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…

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

Watch video<

Smartsheet Basics

Discussion List