Smartsheet Basics

Archives for July 2023

Copying a value from a multi-dropdown to another sheet
Hello, I have a sheet where one of the columns is a dropdown with multiple values in each cell; need to know if it's possible to copy a specific value from those in the cell to another smartsheet with a multi-select dropdown. Thanks in advance.
What is the best way to display the Duration column on a dashboard when I have over 1500 rows ?
Hello here, I would like to display in a dashboard the duration column which is the time that the task took to be completed. What is the best way to display the Duration column on a dashboard, when I have over 1500 rows in my sheet? Is there a way to break it down by ticket type and take the average ?Could you please help…
How to consolidate different parent & children row from multiple sheets, into one summary sheet?
Hi! I am working on a Consolidated Team Productivity Report. From 5 different sheets, I would like to create one summary sheets that will automatically capture same projects from those sheets. (these are common collaborative projects of the team)
How do I share questions and answers with everyone that submits a question on a form I created?
I am doing a presentation. There will be a period for questions from the audience. I also created a qr code that goes directly to my smart sheet form. I want share the questions and answers with everyone that submits a question on my form.
how can I open Smartsheet and go to the current task (row)?
I would like to open a smartsheet schedule and automatically go to the current task based on the start / end date, How can I do that? I know I can ask the smartsheet page to open to the "Today's date" but I would like to align the current task. Thanks
Best Practice for connecting sheets
Hi everyone. Can you help me with some ideas on how to best connect sheets when using a basic Smartsheet plan? I have a Master Sheet that houses all properties. But then on various sheets, I'd like to list details. For example, the master sheet would feed information into a sheet that tracks lease information. Another…
What happens when a user account has been deleted?
We do a lot of collaborating on our sheets with contractors outside our organization. What happens when that contractor leaves their employment and their company deletes their account? Does all of the data/contributions the contractor did on our sheets remain or do they disappear when their user account is deleted?
Transfer ownership of Smartsheet items
We created a workspace and made our client (from a different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client without having to do it one by one for…
Transfer ownership of Smartsheet items
We created a workspace and made our client (from different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client (without having to do it one by one for…
Is there a way to create a mastersheet where...
Specific rows/colums can be seen by specific users on their own sheets, even when changes are made on either sheet. Meaning, I want one mastersheet. EX: I want user 1 to have his own sheet, which are columns 1-120 on the mastersheet. And user 2 to have his own sheet which is rows 121-145 of the mastersheet, etc. But if…

Trending in Smartsheet Basics

Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?
AI icon disappeared
I noticed the AI icon disappeared and I am unable to use AI in my sheets.
Why am I not getting a workflow notification email when I trigger the action?
A notification is triggered when I or one other person enters a date in a field. When the other person enters the date, we both receive the notification email; however, when I enter the date, the other person receives the email, but I do not. The other person is the owner, I am an admin if that makes any difference.

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

Watch video

Smartsheet Basics

Discussion List