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.

Using forms to update a row
I would like to use Smartsheets as a check-out/check-in for handing out laptops at an event. I want to use the forms to update a row when the laptop has been handed out and then when returned. Thanks
Moved: tick check boxes in a column at once
This discussion has been moved.
Color Coding In Progress Tasks within a Specific Time Period in Gantt Chart
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional formatting to fill the cell background of tasks with specific start and complete…
How to pass Row Number to MATCH function?
Hello all! I am trying to work with the MATCH and VLOOKUP functions, to create alerts to let people know it's time to begin their assigned work. For example, if Task 2 is a predecessor of Task 3 (that is, if [Predecessors]3 = 2), I want to do a MATCH and VLOOKUP on Row 2 that shows [Assigned To]3. That way, when [Status]2…
Problems with some users portfolio dashboard access
Hi, I'm hoping someone can help me please! We have a portfolio dashboard for our programme areas, and within this programme dashboard you can click on a link to take you to a list of all projects which sit within this programme. Most of us see the full list of projects whether we have the projects shared to us or no (if…
'Editor - Can Share' users cannot run reports?
I started my new position and am the new Admin for Smartsheet at my work. We converted the Workspace permissions for the owner to 'Owner' and me to 'Admin' and everyone else in our office to 'Editor - Can Share'. For some reason, nobody can use the Report Builder to run a report unless I share that sheet with them and give…
Alerting Somone So they can only see a certain row in a sheet
Good afternoon We want to start using Smartsheet to issue purchase orders and keep a PO Log but we want the people in our "Contact" column to only be able to see the row that pertains to them. Is there a way to do this? Thank you
Due Date Hierarchy
Hello smartsheet community, I have a sheet that consistently uses larger "buckets" or categories under a hierarchy and the due date column always reports the latest due date in the column. In case 1, the way due date hierarchy reports the due date and start date results in sooner due dates being overlooked and that might…
Automated Update Request - Loses custom email with multiples
I need to automate update requests and I am using the custom email to give instructions and they are completly lost when there is more than 1 task to update. ?? Thank you for any suggestions, Lyz
Save Button For Webforms
Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform all of which have a general response from employees saying this will get added as a possible future update. it has been about ~2-3 years in some cases. As a user community, this is an important function for data…

Popular Tags

Trending in Smartsheet Basics

Report Editing
How do I change the font size, color, etc.. on a report to make it look nice?
Standard Size Dashboard from Expanded Dashboard
I have a Dashboard that is in Expanded Size, but am making a similar Dashboard that I need in Standard Size. Without having to recreate all of the widgets and start from scratch, is there a way to convert an Expanded Dashboard back to Standard Size?
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags