-
Row Link - Can it be extracted or used in an Alert or Form?
My users are getting a little lost when they are sent to a sheet via an Alert or Update Request. It would help if there was a way to point them to the correct row. I know you can get to the specific row via selecting the row, right clicking and selecting "Properties", then looking under Row Link, and the URL/hyperlink…
-
I need to match order numbers between 2 sheets and add checkmark for complete
I have an API that brings in new orders to a sheet called "new orders" I also have the API that brings in orders as they are shipped in a sheet called "orders shipped" I want to be able to find all the order numbers in "new orders" that match the order number in "orders shipped" so I can check complete on my "new orders"…
-
Notifications for Only the Requester
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
-
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
-
PMO Efficiency - Workspaces and Automated Backups
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
-
How do I auto populate subtasks dependent on a main ''Task Title'' selected from a drop down list?
Afternoon, Basically I have a smartsheet to track marketing tasks and subtasks. I have some tasks, where when selected I'd like a list of subtasks to auto populate on seperate rows underneath the main task (and indent as well if possible) I've tried using the INDEX (COLLECT) function where when a specific task is selected…
-
Copy specific cells to another sheet
Hi , Is it possible with automation function to copy specific cells from choice to another sheet with out copying the complete row with all columns For example To cop cells in column A, B and F to another sheet without copying middle cloumns D, E etc Thank you
-
Is there a way to group like or same project request forms?
Hello There! My team utilizes Smartsheet for streamlining engineering requests. Both customers and employees complete a form, which is then incorporated into our spreadsheet for task assignment. The form includes a section where users can input previous requests related to the same project, but this is often left blank due…
-
Search function in a form that searches the Data in the Smartsheet
New to Smartsheet. I have a form that collects information when we issue PPE to our employees. When the employee enters their employee number, I would like the form to search and display when sand if the employee has been issued PPE prior and when it was issued. This will allow us to request the old PPE (safety vests or…
-
problem with automation
I regularly get a mesage telling that I am missing a component for the automation to complete, and that I should contact Support for that. So here I am Thanks in advance for a fast reply
