-
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
-
Is there any way for unlicensed users to generate docs when Upload Attachments is turned off?
For security reasons (i.e. unable to specify which server the attachments are stored on) I have to leave the Upload Attachment option turned off. Box attachments is our only selection. Due to this, the Download option under Generate is the only method that works to get a document - and that is only available for licensed…
-
I have a single cell I want to auto-add the sum
I have a cell that is for quantity of material used. Say I put in 3000. Tomorrow I want to put 2000, instead of manually adding it together to get 5000, how can I make that cell auto-add to get 5000 and not have to add it manually together.