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 create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
Not allowing me to save the Automation
Hi Folks, I have Enterprise license and Admin privileges on the Smartsheet which my teammate has created and even then I am getting the below message. And this happens only when i add Request Approval automation step. Any suggestions are appreciated. Regards Ajay S
Unable to open smartsheet backups
I have a few workspaces scheduled for recurring weekly backup. These backup downloads used to work perfectly , until we started to notice a change in how these downloads were available to us. I understand that I need to use the link from the "Smartsheet Backup Complete" and follow the procedures set. " Click here to…
Document generator - Font/Data error
The smart sheet document generator is showing erratic values; it used to work fine previously; however, any new document generated now creates an error; if I type ABCD in the smart sheet cell and then generate through the document generator, it will show something like (e^pp^k or olp^ifb) instead of ABCD as desired. Any…
Filter function in Dashboard
I am building a dashboard using a report for the data source. I do not want the dashboard viewers to have to click on the widget and open the report to manipulate the filters. What I need is a way for the viewer to filter the data in the dashboard. Is that possible?
Row Limit Change
Hi SmartSheet, Did a release happen recently that expanded the number of rows allowed in a sheet past the 20,000 limit? If so, what is the new limit? Is there a communication that went out about it? I know this is on a RoadMap but have seen any updates on it.
Is there a way to send out automate sending out dashboards weekly?
We use dashboards regularly for status reports, is there a way to send weekly to specific individual either as .pdf or interactive? I found this discussion and know it is on the roadmap, anyone know if it has been developed?…
Timeline view - grouping question
Hi all I have a sheet with two columns I would like to group information by - one is the Project Name, and the other is the Workstream name. Both are dropdown columns. A project may have one or more workstreams, and they will vary project to project. Within each workstream is a series of milestones and other information we…
Moved: Automatically Copying Cell Data in a Row
This discussion has been moved.

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