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.

Update triggered by day of month, repeat daily until complete
Sending a single update request does not always generate a response because many people are not good about answering all their emails, and then it gets lost in old email. I'd like to generate a daily update request that begins on a set day each month (like the 14th) and repeats daily until the person completes the update…
Any workaround if database exceeds 5000 rows and need vlookup function from other sheets
If I need a database page where other sheets can pull information from it, to standardise data input, but having the following criteria/situation: 1) database page will keep information for 1 year (database = employee data) 2) will exceeds 5000 rows / 25,000 cells within the 1 year duration 3) cannot move row away as other…
clone filters from one sheet to another
Hi, I set up 5 filters in one sheet. I have 20 more sheets with the same columnar structure. I want to "clone" the 5 filters into all the 20 sheets. I don't want to do it manually. I don't want to do the "Save As New" because the 20 sheets have been established already. How can I do it? Thanks, Shinya
An early look at new capabilities coming soon to the Smartsheet Online Community
If you’ve read the post here or talked with us at ENGAGE, you may be aware that there are some really cool changes we’re making to the Smartsheet Online Community to help you more effectively find and share information with other Smartsheet users. Today, I want to share a little more about some of the features you’ll see…
Filters on reports?
HI, having created a report which is a summary of several sheets, I can easily sort it...but I cannot see a 'filter' option on the report. Does anyone know if this is an option? cheers mike
Add a Chart from Smartsheet Labs Charts on a Dashboard in a Workspace
Hi, Gentlemen. I created some charts on Smartsheet Labs Charts but i can't add them into my workspace on Smartsheet. How do i do that? Above is a print screen of the charts i created. OBS: I have already tried to upload via URL (URL and embed code). I was not successful. I need help guys.
Lost INFO
All of a sudden I lost information. Not sure how I did it or if something happened. I'm trying to "Recapture" and maybe go back to an earlier "saved" file. Does anyone know if this is possible? Robert
Auto Expanding Form
Hi everyone, I'll try my best to articulate my question. Is there a way to auto expand a form to take multiple entries, instead of one submission per entry? I want the form to be as short as possible and only expands if there's another entry (similar fields). For example data set1 has Part1, Part1 Weight, Part1 Dimentions,…
Multiple criteria for approval workflow
I need to create an approval workflow where 2 criteria need to be met but it seems the only option is "or" and not "and" (see screen shot). Is there a way to have an approval sent out only if both criteria are met?
Hyperlinks not exporting
I am trying to export my smartsheet to excel and whenever I do this, all the hyperlinks are gone and I have to enter the hyperlinks again manually in the generated excel spreadsheet. I tried exporting to google docs and the same issue. Hyperlinks are not exporting. Why? Please assist. When I tried to log into the…

Popular Tags

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags