Smartsheet Basics

Archives for June 2022

Automatically create widget in a dashboard but with a certain widget behavior
If a new project is created in our Smartsheet, Control Center creates a dashboard automatically. Is it possible that Control Center creates an Image Widget with the Widget Behaviour where another sheet or form is linked? At the moment Control Center just creates Quicklinks but we want to realise that with buttons on which…
Add license & Upgrade plan tab is not getting opened in smartsheet app.
Please suggest how to get Plan activation. Is their any alternative for this?
Which plan access will have all the access to smartsheet entities like sheets,sights,groups etc?
How do you automatically pull assigned tasks to an individual's 1:1 sheet?
Elaboration: We would like to have our employee 1:1 sheets automatically populate with all tasks that are assigned to who that 1:1 sheet is designated for. Example: Pamela is assigned tasks in sheet 1, 2, & 3. When Pamela opens her 1:1 sheet, we would like to have the tasks assigned to her in various sheets automatically…
How can my Dashboard display hours instead of days?
I have a report that summarizes the hours assigned to each team member in my project., and a dashboard that shows that report's summary fields. However, this summary is in days. I would like to display it in hours (7.5 * days). How do I do this? My first guess was to create a new sheet that referenced the report's summary…
Move Row Automation lagging terribly
I'm leapfrogging rows from a form collection sheet to an intermediate sheet, and that move row automation works fine. From the intermediate sheet, I'm moving rows to the main data sheet. This is where things are lagging, like stopping for multiple hours for no reason. The rows that are moving have only 5 columns. There's…
Lock/Unlock specific column based on another entry
Is it possible to lock/unlock a column depending on the entry in another column? Thanks
Automation - Copy Specific Cells to another Sheet
Looking for a way to copy specific cell to another sheet. I know how to do a full Row, but in the other sheet we are not looking for ALL of the columns and only certain columns are needed in the other sheet. Is there any option or creative solution for a flow like this? GOAL: copy the contents of a few cells ex.…
Copy and paste with formatting
Is there a way to copy sheet information that is formatted from one sheet to another and maintain the formatting?
Smartsheet and Resource Management Connectivity
I know how to update my sheets and upload the changes to Resource Management. I am looking to just update the Resource Management schedule (start and end dates, assigned to, etc.) directly and have the edits carry over to the sheet it affects. I have been told at least by a smartsheet representative and read online that it…

Trending in Smartsheet Basics

Can others share into a Workspace where I am the owner?
I am creating a scheduling workspace that has 50 PMs. When one of the PMs need to create a new schedule, do I have to be the individual to create since it is in my workspace and should be placed in a specific folder for reporting? Or can they save into a named folder in the workspace?
Does changing the prefix of an auto numbering column stop a row from transferring to another sheet?
I have two sheets; one is an originating sheet that has an auto number column. For this sheet, I designated the prefix of 'WO26' for the numbering convention. The 2nd sheet is a 'dumping' sheet that started off blank; due to the addition of the rows transferred from the originating sheet, corresponding columns have been…
Testing Table View with over 20k rows
Hi, I'm trying out some proof of concept stuff for a solution that will have over 20,000 rows and needs to interact with the sheet in Table view. I've used DataShuttle to put in the rows, I was able to open the sheet in Table view once, but then I tried going back to grid view and just get this error message. Problem is…

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

Watch video<

Smartsheet Basics

Discussion List