-
Dynamic View Entries
Is there any way when you are using Dynamic view that once a "NEW" entry has been entered, like in forms that you can select that new entries go to the top of the sheet?
-
Mirroring Smartsheet
Good morning! We have a master smartsheet with employee info that we would want to mirror so we can have some of the employee info on different sheets that we can use for different tasks. Currently want to mirror employee number, name, work area from master to a new one. I tried to use data shuttle offload from the master,…
-
Data from one smartsheet to another
What is the best way to pull multiple columns of data from one sheet to another? In sheet "A", I have a unique number. When that unique number is keyed into sheet "B", I want to pull the next 20 columns of info associated with that number into sheet "A". I know I can use index/match, but I don't want to have to key a…
-
Control Center and Contact Columns
I am using control center to create projects. In the sheet that gets provisioned, I have my resources listed. I want to bring the "Lead" contact back into the Intake sheet, but it is coming back as just text and not an actual Contact. We use the Current User view for project updates, which won't work this way. Any ideas on…
-
The sheets of the workspaces I own are deleted by themselves every day
Good morning, greetings. Since I renewed the license, the sheets of the workspaces I own are deleted by themselves every day, please how can I solve this problem?
-
Formula for cell Link
Hi SS Community, There is a single cell with a hyperlink in our project metrics (metadata) sheet that we want to display in every cell in a column in another sheet. The idea is that we can create a dynamic report across all of our projects and include the column for the respective hyperlink so it will be right there on any…
-
Move Row/Copy Row Automation flowchart
Hi Smartsheet, I'd like to have a high-level Smartsheet view that shows, in a visual, the "Move Row" and "Copy Row" automations from one sheet to another. This would be extremely handy when communicating to management or onboarding new employees to existing Smartsheet processes. Additionally links directly to the sheet on…
-
Return a value from a cell based on today's date
Hello everyone, I am creating a metric sheet to track the total hours, attendees, and person hours of meetings and would like to track it based on today's date. In the example above, I would like to use TODAY() in the top row under the "Date" column. Then if the date in the rows below are in the past, return the…
-
Restricted Task Dates in Office Timeline Pro+?
I use Office Timeline Pro+ to create all my corporate project timeline slides by importing source Sheets or Reports. Is there a way to show project timelines restricted by a certain date? For example, I want to show all tasks that are in progress as of 1JAN2024, regardless of the actual start date (e.g., if the start date…
-
Sending responses from intake form to two different sheets.
I am in the process of creating an intake form and would like the responses to go to two different sheets based on a trigger word. Example: We have two different departments (Sales and IT). The request form I created allows the requester to enter which department the request should go to. The select department column is…
