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.

Create an automation to set column value on a new row
I'm trying to create my first automation, and although it seems like a dead simple use case, I can't get it to work. I simply want a default value for one of my columns. It's a drop-down column, but it looks like SmartSheet doesn't support setting a default value, and an automation is the recommended approach. So I'd like…
Conditional Formatting in Numbers
This discussion was created from comments split from: Conditional Formatting of numbers.
Backup Download Zips Not Extracting
Every couple of weeks we have an automated backup created and we download and save them offline for record retention. We have been doing this for almost two years and at first the data could be extracted but now every single file gives us the error message below and nothing can be extracted. Before I go to our IT Team with…
Can I make the image not downloadable when I click twice?
I pasted the image into the cell. I just want to see it and not download it except for the admin. Is there any way?
Workflow to transfer Parent row and not Child rows
I have a workflow to transfer data from one sheet to another however I only need the parent row to transfer and not the child rows. How would I do this?
Moving rows
When I move rows from a master spreadsheet, beginning with row 1. My rows are moved to row 928. Do you have any ideas why this is happening?
Error: Unable to Add Rows – Destination Sheet Lacks Sufficient Cells
This discussion was created from comments split from: Rows could not be added to the destination sheet because it did not have enough cells remaining.
Pro plan limitations
When I try to make a report on multiple sheets it tells me to upgrade my plan to pro plan. I'm already a pro plan subscriber.
Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
Possible to Undo Sorting from a Day Ago?
Hello all, A colleague asked me for help with something in Smartsheet I could not solve so I wanted to ask for the community's thoughts! A collaborator sorted a sheet based on a particular column (in error) and were unable to undo it. This is the next day and I did not see any way to undo (additionally, there were no other…

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