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.

Embedded sheet in dashboard - problems
HI all I've embedded a Smartsheet sheet in a dashboard and it displays as tiles (which is what I want). I'm the owner and there are two other collaborators. They have been able to open the tile and add content to the fields but now that's stopped. They can open the tile, scroll to a field but when they start typing, they…
Executive Update Templates - stoplight
Does anyone have any good executive high level templates you can share? One is the stoplight approach.
Problems with conditional formatting
Hi, I am trying to apply conditional formatting to a cell if it is blank. The issue I am having is that the cells I want to apply this to have a formula in them (=IF(Name16 <> "XXX", "N/A", ""). The conditional formatting doesn't pick up the "" as being blank. Have tried a few workarounds but haven't found a solution that…
Enabling updates to start / end dates with dependencies
Hi There - I would like to enable the workflow described below, which doesn't seem possible based on my read of various community posts. Would welcome ideas for how to work around / address. So far I have set up the following: * Task lists set up with dependencies * Tasklist also has hard coded planned start / end dates *…
Dynamic Views- Wrap Text?
Hi, I created a dynamic view for the first time today, but can't seem to get the text on column headers to wrap in the view; I didn't see any option for adjusting the column width either. Any ideas on how to do this? Thanks!
Formula that takes a Start Date from one column and calculates number of days populates another colu
I have tried a number of formulas in an effort to - enter a date in one column / row and have it calculate out 30 days and self populate a date in a different column / same row . This date column is already part of another calculation dependent on a completion date to give me how many days past due . I have a check box…
Legends on Calendar
Is it was possible to add a color legard on the calendar view? I noticed someone else asked a year ago and wondering if maybe Smartsheet made this possible. See screenshot.
Request Approvals
Hello All, We are creating a time off/work from home request sheet for our Director of Operations. We have been testing the sheet and it's notifications and noticed each time a request is approved, the D.O. receives an email. We tried changing the settings so that the alert was set for when a row is added not when a row is…
Uploading Users / Resources
Aloha, new to Smartsheet set up from scratch. Using free 30 day trial and tried to load users (80), but seems it surpassed the max allowed number. do you guys know how many we can use? Also, please help understand how to avoid sending email notifications even when the upload FAILED. Thanks!
Expliciting a sheet name with Strings
Hi all, I would like to calculate the sum of elements in a column (say the 3rd columne) on another sheet. The sheetname is in a column "NameSheet" The following SUM("{" + NameSheet[1] + " Range 3}") does not return anything. I know Excel has something like Indirect() and it would be SUM(INDIRECT("{" + NameSheet[1] + "…

Popular Tags

Trending in Smartsheet Basics

Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags