-
Automation condition equal to (find and replace) ?
Hi, I have a sheet with information on if an inspection has passed or failed. If an inspection has failed then a new row is added to the sheet saying the inspection has passed then I want the failed row to be deleted. I want the automation to find the matching part number. This is a sheet that is being updated daily so I…
-
Making an order request form but need the ability for multiple items entered into the same order
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
-
Add data to Smartsheet by connecting to any API
I built a Smartsheet App called API Retriever that allows you to connect to any API, pull your data, and import it into your sheets. Check it out at https://www.apiretriever.com I'm happy to assist if you need any help creating a request. Let me know if you have any feedback or need any assistance!
-
Not receiving emails via automated workflow
I've set up a grid to capture and track certain issues that need to be raised. I've also created an intake form so that the team can easily submit anything they need. We need to set reminders for the team to enter info on the form each week so I've created an automated workflow to regularly send a message-only reminder to…
-
Adding comments to approval process
Dear smartsheet-community, I am using the approval process for new incoming projects. Basically if a new project/line is added, an approval request is sent to 15 team leads and their choice (confirmed, declined, pending) is stored in 15 columns representing the 15 teams. Question: Is there any way to include a…
-
Automation by changing the position of a row and hierarchical level in the primary column
The entry of new records, such as opening a ticket in the help desk, always places the new record in the final position of the grid. It would be interesting to be able to automatically place the new record already within a desired hierarchical level in previously created lines. For example, using the existing template for…
-
Forms: how to move some column data to a new row
Hello, I am using a form to collect HR job / position requests. The upper portion of the form collects administrative information, the bottom portion collects position and financial information. The problem is that people often want to submit more than one job. The current state requires them to open the link again and…
-
Reports: Column Formula Updates
Hello. I attended SmartSheet Engage 2022 - and was so excited to hear that column names would auto update when changes were made on the sheet without having to update each report. I believe they said this was already a feature. Unless I'm missing something, my reports are not updating based on the columns on the sheet…
-
Proof into columns
I have created a proof and did the "Proof into columns". Columns 'Change required by' and 'Date Completed' are not updating. Also automation will not detect condition "Where Pending Approval from is not blank". Are there issues with using Proof into columns?
-
Automated Approval for multiple users
Hi all! I am working through creating an action checklist in Smartsheet. For some of the tasks (which are identified on a per row basis), I would like to send automated approvals to multiple users, be able to track sign offs, remind individual users who have not signed off, and have a final document displaying all the…