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.

Post most recent comment to dashboard
I have a project tracking sheet that is updated weekly with the most recent updates for project progress, issues/concerns, barriers requiring intervention and next steps. How can I display only the most recent updates for these 4 columns in a dashboard?
How do you apply the same conditional formating to multiple cells?
In excel I can create a formula in a cell, then create conditional formatting on that cell. For example, I can do a quick formula to compare to values. If the value is <0 apply a format that makes the cell red. I can then cut and paste that cell into any other cell I want in a spreadsheet and it gets the formula and the…
Creating a Template with System Columns
I want to create a template with columns and rows. I'm including system columns. When I add rows the system columns automatically populate, of course. But I don't want those dates and names to be filled in in the template. I'd like them to be blank in the template and in the sheets that I create from the template, so that…
Duplicate a column, including properties. in a sheet.
Is there a way to duplicate a column including the properties (Not necessarily the data)?
Duplicate Column with Properties
Hi Everyone, I have a contact column that restricts cell values in that column with the emails of everyone in my division of my company. This is so that an email cannot be mistyped. I have 100+ contacts added into the restriction list and I need to make several other columns with the same list of emails within the same…
Automation and Forms
If i have a Microsoft template that i have to collect information and fill out. If i created a form to collect the information that's needed for the Microsoft Template, Is there a way to utilize the information from the sheet to automatically fill out that template and email it out to respondents on the list?
Can a Viewer Respond to an Update Request?
Can''t find an answer to this. I need people to be able to respond to update requests and enter info there, BUT NOT enter anything at the sheet level. Can a viewer do this? Thank you!!
Changing Colors - Card View
I can't figure out why the colors aren't showing up in card view with conditional formatting. It's working fine on grid view and table view. I have tried coloring everything or just the status, and "high priority" items should have red text. When I go to board view, it tells me to go to card view to change the conditional…
Recipients of an automated workflow notification are not receiving emails
"Hello Jake, a recipient isn't receiving alerts from Invoice Status Update" notification We created a form that feeds into a grid sheet and it has automated workflow to notify users from a cell (client emails) when criteria like "Received" and "Completed" are met Most of them work fine, but we have a group of them which…
Upgrade my plan
when need to check my plan and upgrade it, it always show screen " it show we ran into error please refresh the page" any clarification whey the happend

Popular Tags

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 のご利用を開始するために必要なすべてを網羅しています。

Trending in Smartsheet Basics

Last date formula question
Hi everyone, I have a sheet that has various steps for people to complete. As they complete their task, the date is recorded that it is completed. What I would like to show is most recent date of completed so that I can show the last step completed date and then what the last step completed was (the column title of the…
Formula to count # of tasks overdue based on date
What is a formula to count the # of tasks that are overdue, based on a date?
Need both Text and Contact List versions of people on same sheet
I have a PowerBI report that pulls data from a Sheet. When I use a contact list on the sheet, the email address shows on the report, not the name. The customer wants to see names, not email addresses. I need the contact list column because I have reports that filter on logged in user. I don't want people to have to enter…

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

Watch video<

Smartsheet Basics

Discussion List

Categories

Popular Tags