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.

How to lock column in report
How to lock column in report
Automated Monthly Alerts
Alert Trigger I would like to send an "alert" each month on the 14th for rows in a sheet. I would prefer not to update/maintain this each month or year but just have it automatically go each month. I created a data column called Today using formula =Today() to return the current date and a text/number column called Trigger…
Filter on Contact not working
Hi We've recently had reports that the filter on a Contact column is not longer working. If you select 'Is Equal To' and then select the contact from the dropdown, the smartsheet used to filter on that selection. Now it returns 0 rows. The workaround, which is far from ideal, is to use the 'Contains' option. We've also…
RYGG Automated
Hi all, I am unsuccessfully trying to create a formula for the following RYGG column: Column [Project at Risk] with the RYGG: * If [PROJECT START] (date) is more then a day over I want the [PROJECT@RISK] to display "RED" ball * If [PROJECT START] (date) is less then 7 days away I want the [PROJECT@RISK] to display "YELLOW"…
Dashboard with white background prints gray and colors for images are off
I have a dashboard with a white background and when I select print to PDF, i get the gray background color and the image objects are white. I don't see any color settings when I select Print to PDF from Chrome.
Web form setup
Hi all, I have a little issue with web form setup. How can I switch off checkbox >Send me a copy of my responses<. I don't see it in a web form on my pc, but it's still there when I open form in my mobile device. I don't need it, so how can I switch it off?
Cell linking - From column to a row
How do I get around where cell linking puts my data? I’ve created these columns in my roll up sheet.(first capture) Now I want to link and have all the data display in a row. (just like you see in the second row, (I had to cell linked each one individually, not good) My source data/intake sheet, data is listed vertically…
Can't access any sheets when they're shared with me
Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me and i'm listed as a…
Printing View/Dashboard Title in Color
Hello, Is there a way to print a view/dashboard (to pdf) that retains the color background of the title shapes? The text in the widgets do print in color - it's just the background of titles that reverts to white. thanks, -Peggy
Dropdown to determine value on another column
A little help... I want to use a dropdwon column value to populate another cell with a predetermined value from a lookup column. The attached screenshot - Unit Type is the drop down and I want it to correlate to a value from pricing columns and populate the unit rate column.

Popular Tags

Trending in Smartsheet Basics

Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags