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.

An Alerts and Actions rule has become invalid
Overnight I've received 20+ "An Alerts and Actions rule has become invalid" emails from smartsheet due to an employee who left our company several weeks back. Although his account was removed via LDAP, his email address exists in smartsheet alerts across our corporate smartsheet account. Is there a way to completely remove…
Configure "Request to join Smartsheet account" recipients
Currently, when existing contributors within our organization request a full license via the web application, an email is generated and addressed to the SysAdmins within our instance. My preference is that those requests be directed to a single inbox for L1 triage, instead of creating email noise for our IT architects. Is…
Update end date when complete is checked
Hi. I would like for my tasks' completion dates to be automatically updated to the day that the task is completed (i.e. when the user ticks the check box, etc.). I already understand the whole idea of task dependencies, that's not the issue. My ultimate goal is to automatically update future dependent task due dates based…
How to hide rows on a list?
Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
Cell with leading whitespace
An unorthodox question but posting as I'm sure our company is not the only one who sometimes uses Excel as a Word document ... We have an Excel document that we are importing to Smartsheet, and Excel allows the use of leading white-spaces in the cell so that overall the document reads better e.g., Row 1: Title 1 Row 2: -…
Is there a way to add the 'today' bar to the Gantt view on a dashboard?
When I look at the Gantt chart on the sheets and in reports, there is a nice marker indicating 'today' which gives a great reference point. You can see this as a vertical dashed line in Capture1 below. When I create a dashboard using the same report I see the same data, however there is no vertical line indication where we…
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
If this then that
Does Smartsheet have the ability to move rows to a new sheet based on a condition being completed? An example would be if you have multiple projects (rows) on one sheet and want them to be moved to a new sheet when the status is changed to complete. Is that possible?
Time tracking for Collaborators
Hello If I set up time tracking in a sheet, can that be accessed/used by free collaborators? Thanks Megan

Popular Tags

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags