-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
Improved User Auto-Provisioning
It would be great to be able to specify some additional options for user auto-provisioning: Have the ability to add auto-provisioned users to Groups automatically - Being able to add new users to an "All Employees" group automatically would mean they could have access to some resources by default. In my case, users…
-
Remove "automation@app.smartsheet.com" from sender email address
The OIT Security department at my university received a report that an email from automation@app.smartsheet.com may be phishing. We send a number of Update Requests through Smartsheet that require action from the receiving party. If the email is perceived as phishing by the recipient (or flagged as Spam by the email…
-
Inventory Workflow to only include fields with missing items
Hello Smartsheet Gurus! I am attempting to create a workflow that notifies a team about low inventory in an email. There are multiple teams in my org. Each has responsibility for about 20 items. I have the workflow set up to only notify the team of their items status but I can't quite figure out how to notify them only…
-
Reminder automation
Hi! I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up: Several farmers markets have…
-
Forwarding Approval Requests
Hi All, I am developing a system that involves a large workflow of approvals. I have it set up so that the user selects a person for each approval to go to. However, I want to be able to have the person who receives the approval, be able to defer the approval to a superior if it is necessary. I found that forwarding an…
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
Record an Approver Name once Approved using Automation
Hi, I am looking for a solution to record the name of the approver when using Approval Request automation. I can see there have been few questions/discussions on this, but can someone point me to the solutions - without using Zapier :) For example, a request to approve a report is being sent to John, Jack and Jerry. Jerry…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
-
How do you confirm the identity of an approver in an approval request?
We discovered somewhat alarmingly that the Modified By column does not record the email address of a person making an approval but rather pulls information from the cell in the approver column. Here is the use case: An approval request email is sent to Person A, who forwards the email to Person B. Person B approves the…