Smartsheet Basics

Archives for June 2022

Printing Reports
Any updates on when Smartsheets will print reports with the groupings & totals you can see on the screen? Thanks!
Create a List of Linked Cells
Does anyone know how to create a list of all of the linked cells contained in a summary Smartsheet? Thanks in advance! -Mike
Any easier way to find/remove inactive users from 'Automations' / recurring 'Send as attachment' ?
Minus opening each sheet, report or dashboard a deactivated user was "shared to", is there a more efficient way to find (and remove, ideally) their email from any 'Automations' and/or recurring 'Send as attachment' rules? Thanks!
Apostrophe ' being added to duration column after using the form
Hello, I have a form that I occasionally use to enter data into my sheet. Every time I enter data it adds an apostrophe before my duration text causing it not to populate a finish date. For example, instead of carrying 3d (3 days) from the form, it carries it over as '3d. I've replaced the form with another and it…
Is there a way to minimize or hide the sidebar showing who is shared to Workspace? This impedes on
Is there a way to minimize or hide the sidebar showing who is shared to Workspace? This impedes on what can be viewed in the actual workspace.
Contact List Column - Limited visibility of Dropdown List in a Cell
I have a Sheet with a Contact List Column. The Values has about 80 Contacts for the Dropdown List. If I build that Contact List Column into a Form then all 80 Contacts can be selected in the Form. Once that Form has populated a Sheet Row, if I go into the Cell in the Contact list Column to change the Cell value then the…
What am I doing wrong to receive this message?
I've checked the Blueprint/metadata everything matches up. Has anyone received this error and might have insight into what it could mean?
Emoji Showing on Grid - Not Showing in Print to PDF
Using emojis is a game changer for tracking data and keeping visual clutter to a minimum. However, we still need to keep physical copies regularly for the sake of archives. The Issue: When printing the sheet to pdf, the emojis used do not appear. I've created a sample that does not use any confidential or non-secure data.…
Assign Multiple Users from a Form
Good Morning, I have a form that has a few check boxes. Depending on what checkbox is selected, different people are assigned to a task, but it's for a single entry/row. Is there a way on a form to make the assign column (which is already set to a multi-contact) assign to several users in the single assign field from a…
At risk flag formula help (please!)
Hi there, I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%. Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so…

Trending in Smartsheet Basics

Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Workload in Table View
Have any of you tried the workload in Table View? We have a Business contract but I still cannot get it to work. I have made sure I had the columns needed, formatted as required, and no blank spaces. My apply still comes up grayed out. Any suggestions?
Is there a way to know when a baseline is taken?
I am trying to find out when a baseline was taken and I can't see how or if this is possible.

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

Watch video<

Smartsheet Basics

Discussion List