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.

Lock a Column (Prevent it from being moved to a different area)
Hello, Is it possible to have a column header be locked in place. For example, a spreadsheet with 5 columns titled 1, 2, 3, 4, & 5. Someone keeps moving column 2 next to column 5. We want to prevent other users from dragging column headers to different locations. Thank you!
Smartsheet Builder | Test Out
Disregard - deleted.
Disappearing Links
I had several links (URLs) saved in a sheet for quick access to frequently used resources. All of the links (URLs) have disappeared. Many links were to Google Drive resources. What caused the links to disappear?
Portfolio Template with Capacity Waterline Help
I'm thinking of transitioning my current project portfolio to this template that includes a capacity waterline but I'm having trouble getting started. Usually the templates include a guide on where to start and how the data flows between the sheets, reports, and dashboards but I can't find it for this one. Thanks in…
How do i copy a conditional format to create an automation?
Hi, how do i copy over conditional formatting cells to another sheet using an automation? The conditional format is 'if the PCI due date is in the next 30 days and PCI sent is blank then apply this format (changing the text colour) to the PCI due column' - we want to then put this into an automation so the row is copied to…
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
Send row attachment with automation
I am looking for instructions to send all of the attachments on a row with automation. Here is what I currently have: Trigger: When a row is changed and an attachment is added Action: Alert Someone - send to specific people When the automation runs, the attachments are still not in the email. Am I missing something?
Web Content Form Not Working on Reload
I have a web content widget on my dashboard that displays a Smartsheet Form. I have the form set to reload the form for another entry when an entry is submitted. When the user goes to use the newly refreshed form, dropdowns do not populate (i.e. Contact Lists). Dates and text work fine.
Sheet Loading and Saving
Hello, I have been having this issue quite a bit with many of my sheets. how do i get SS to check my region as well ? Kind Regards, Wesley.
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?

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 のご利用を開始するために必要なすべてを網羅しています。
Visualize Project Data with Smartsheet Dashboards
Create a dashboard that is collaborative, informative, and easily customized. In this webinar, you'll learn how to: Add and edit each widget type Surface real-time data from sheets and reports Share dashboards with collaborators Insert live, actionable content like videos, forms, and more
Create Real-Time Data Summaries with Smartsheet Reports
Learn how to report on your work at every level with: Sheet Summaries to define, organize, and understand sheet data Reports to consolidate rows from multiple sheets into a single view Roll-up metrics by grouping and summarizing report data

Trending in Smartsheet Basics

SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
How do I update the content that displays when a user selects "Send me a copy of my responses"
When a user submits our form they can select the option to get a copy of their responses. The email they receive has some major formatting issues that need to be resolved - specifically our institution's logo is enormous in the email. Where can I edit the template for people who have elected to get a copy of their…

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

Watch video<

Smartsheet Basics

Discussion List

Categories

Popular Tags