Smartsheet Basics

Archives for December 2021

Smartsheet Training
Hallo, I have completed the Product Certified User Exam. I would like to move further , It would be great to know about what are the next official certification in smartsheets. Thank you.
Using images in cells
I know I can insert the image into the cell. I also can copy/past images into cells. What I cannot figure out is how to combine text and images in the single cell. I have a details / notes column which I plan to use to describe details of requirements (which is a combination of a text and engineering diagrams etc.) or…
Adding colour
Is there any way to change the column name cell colour or even the text colour? I want to use the sheet as a tracker and I would like to make the entry fields for users easily identifiable with a different colour. I don't particularly like the look of having a colour applied to the full column. If this is not possible, any…
Return multiple email addresses defined by role
Hello, I want to notify people through an automated workflow. The notification should be sent to persons related to a certain role and the role-name list is stored in a separate sheet. There can be a single name or multiple names. How can I join contact values, so the joined values will give email addresses? The join…
Selecting a sheet reference from dashboard, report or another sheet
Every time I need to select a smartsheet item from another item (report for the dashboard, item for widget behavior, item in the dashboard shortcut, a source for a report, or a hyperlink to another sheet), the item selection begins from the top Sheets folder. Is it possible to configure that dialog (I am trying to look for…
Dashboards - lock widgets into place
I am building out a dashboard and have widgets in place, but when I add a new one, and move it to the area I want above or between existing widgets, the widgets move and it is challenging to get them back to where I would like them. Is there away to lock widgets so they don't move and then unlock them when needed?
Report - using the Summary option by Count, when the cells are blank it groups by blank but does not
Reports - using the Summary option by Count, when the cells are blank it groups by blank but does not count the blanks and displays '0'. I have about 200 rows that have a null value in the column I am summarizing, but the count is displayed as 0 (zero) instead of 200. How can I get the report to count the blanks?
Can you create a folder on an admin level?
We use Smartsheet for many different projects. Since 2018 we have accumulated many sheets. These sheets are shared with many users, in different departments. Is there a way to organize these sheets on an admin level, for example by construction year, without having to set up the same folders on a user level, over and over…
Create a sprint report based on column values by repeating the row
Hi Community! I have a sheet with distinct rows representing a task and a column indicating various design/build activities by sprint. I need to summarize this data into a new report or sheet to see all the work per sprint. I don't need any other columns/dates autopopulated. Source sheet sample Desired report sample
Can this possibly be true - that Smartsheet doesn't have column validation for numbers?
I'm sat here flabbergasted. Can it possibly be true that Smartsheet doesn't enable you to natively enforce simple validation rules such as: a) Entry being a number b) Being between 2 values Really? I'm baffled by this. Surely the devs would have realised this is an essential feature on DAY 1? I can only assume they are…

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

Membership/ Access question
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
Quick Fill to Multiple Cells?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
Filters not working appropriately
Has anyone else noticed that filters in Smartsheet show incorrect data? In the screenshot below I have the unnamed filter enabled and as you can see it is displaying a date that falls outside of the range given. Any ideas? ~MR

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

Watch video<

Smartsheet Basics

Discussion List