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.

Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
If this then that
Does Smartsheet have the ability to move rows to a new sheet based on a condition being completed? An example would be if you have multiple projects (rows) on one sheet and want them to be moved to a new sheet when the status is changed to complete. Is that possible?
Time tracking for Collaborators
Hello If I set up time tracking in a sheet, can that be accessed/used by free collaborators? Thanks Megan
Notification Not Working
Hello! I am trying to setup an alert to notify me right away if the percent complete changes for specific rows in my Smartsheet. I set up an alert to notify me when "a row is updated" and selected the specific rows (Task Name) I need updates for. When I went to test it out by updating the % complete for one of the…
App for workers in the field
How do i allow the workers in the field to submit info to smartsheets without them having a license
Need help to upload new data from Excel to existing sheet
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
Automatic Formatting: Summary / Parent Task
Good Day All: Is their a way to add a condition for summary task? For example, the condition would be to bold the Task Column if the Task is a Parent / Summary Task. Thanks
Prevent copying data from sheet
How can I prevent to copy data from a sheet to another file? I need share some sheet with editor privilege, but I have to prevent he to copy the data to another place. Thanks, since now.
Global and Workspace Colors Changed?
Our Smartsheet interface colors are all different today. Our custom global colors are changed (although the logo is there). Several workspaces that had custom colors have been changed to match the changed global colors. Is this something Smartsheet did or have we messed up? Thanks, susan
Missing Contact List
Hello Everyone! I was using SmartSheet to create a form. However, when I shared the sheet with a colleague to utilize, the contacts I had saved didn't appear for him. Any advice? R, MA

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags