-
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.
-
Automation for Date and/or Time Change
Hello, I have been struggling with an automation for notifying a group of people about changes in the date/time of appointments. I have doctors submit a form when a new patient consult is created which triggers an email to a group of people. I want an additional notification to go out if they change the date or time of the…
-
Automation copy row into the same file
I have a file that primarily receives information from a form. I'd like each time someone inputs a new item, two additional copies of the same line are generated. The first copy should change one value in the column labeled 'BAF' from 'Budget' to 'Actuals,' and the next row should change from 'Budget' to 'Forecast.' I'm…
-
Alert/Notification when line item hasn't been added
I am building a sheet in which 6 managers provide updates in the form of line items. Each week our Director reviews this sheet for the latest updates. I am looking to create a notification system that would go out to each manager that doesn't provide at least one update (add one line or modify an existing line) in the last…
-
How to prevent row data from shifting up a row?
We have a data sheet set up within SmartSheet (Sheet A) that feeds off our master sheet (Sheet B) that contains all of the current positions within our company. This automation is set up so whenever a new position is created in Sheet B, it'll auto-feed the position name into Sheet A into Column 28 of the screenshot. The…
