-
Changing the name of Sender - Emails?
Good Afternoon Smartsheet Community, How can I change the Sender name of the emails? Currently its saying "my fullname" via smartsheet automation@app.smartsheet.com" I don't want my name displayed in all the emails it's sending as I currently create reports.. so every report automation it sends it out as if I am sending it…
-
What is the time gap used to consolidate the changes made on the sheet and send a single alert email
Eg: I have a automation alert which is when a cell is changed to "Yes" for one of the column on the sheet alert me. I updated corresponding column in row 1 to "Yes" and saved the sheet. Then immediately updated the second row to "Yes" and again saved the sheet. I received one email with details of these two rows. At what…
-
Please tell Smartsheet to improve Contact column contact population/handling!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
Multiple Approvals
I'm looking for a clean, efficient way to handle multiple approvals for a row which contains comments without having a large number of columns. Up to 20-30 different people will be reviewing, sometimes 5+ for an individual row. First thought was to create child rows and add the approvals there and I would only have to have…
-
How do I fix a VLOOKUP problem?
Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the 'test result' column from the form results and allows us to report on anyone who was scheduled to submit a test by a certain time but hasn't (report if blank &…
-
Email validation for Forms or Workflow conditions
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
-
Automation Workflow Sequencing for E-mail Notifications
Hello, I've been rolling out some new sheets/processes to my colleagues and I've run into a little snag that I'm hoping to seek clarification from you awesome Community members. Scenario 1: I have an input form that will automatically assign requests to a user and I also want to send an Alert to that Assigned To user. When…
-
Calendar Invite Automation
Is there a way to send automated calendar invites to something like Google calendar (preferred)?
-
Alert or update if a column value is changed based on the column(primary column)
Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse. In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them. can someone guide me as to how to do this?