-
About the approval request for spesific people
hey everyone, i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person. so, i create the approval request by the trigger with Division 01, and Division 02. But the…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
I am trying to send multiple rows ina automation alert
I have attempted multiple strategies to send multiple rows based on a trigger. The automation only sends the row where the trigger event occurs. Below is the Automation logic, The email that was sent and the data in the sheet.
-
Log of user access to sheets
In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this will show information on 20-25 projects, so automating the solution as much as…
-
Intake Requests Without Form
I am trying to see if there is a way to create rows via email without having our employees use a form. We are currently receiving a large amount of requests from our branch personnel to our corporate office. These are specific requests for a specific department. The requests are currently coming into our Jira help-desk via…
-
Introducing Automated Workflows and Recurrence
Community— We've introduced automated workflows, which make it easier than ever to build, manage, and collaborate on Smartsheet automation. You can now: Consolidate multiple automated actions into sophisticated workflows, including multi-step approval processes Address a variety of scenarios in a single workflow with…
-
Reminders email notifications
Good morning all, I have a question regarding email notifications sent when a reminder is set in a row. Is there a way to set the reminders emails to be delivered at a specific time on the due date specified? Every time we set reminders, we are getting the notifications between 2 and 4 am. This is a bit impractical as…
-
Email Notification to an employee without a smartsheet account
I have a form that our employees will fill out in the field to request a special price. Once that has been approved i want to send an email back to that the employee confirming we have approved their request. I have them filling out their email in the form and have tried to use that in the automation to send them the email…
-
Avoid access to smartsheet when request for update
First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able to reach / open it. I send requests for update with automatic processes. but when counterpart…
-
How to pass Row Number to MATCH function?
Hello all! I am trying to work with the MATCH and VLOOKUP functions, to create alerts to let people know it's time to begin their assigned work. For example, if Task 2 is a predecessor of Task 3 (that is, if [Predecessors]3 = 2), I want to do a MATCH and VLOOKUP on Row 2 that shows [Assigned To]3. That way, when [Status]2…
