-
Trigger a workflow based on Sheet Summary Change (Bridge & Sheet Automations)
It would be nice if we were natively able to trigger an automation based on a change in sheet summary. I would like to be able to set this trigger up in Bridge, along with the ability to do this in regular sheet automations as well.
-
Automation of Update Requests
My team each has a sheet on which they need to ask faculty preferences. I have built out an automation to send the request. When it sends, it sends the request for all the rows, not just select ones. However, testing the automation allows me to select which rows I want to send. How do I build this into the automation?
-
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…
