-
Turn Off Notifications of No Recipients
A new feature (unwanted by me) is to notify me if there are no recipients on a notification. Well, Smartsheet, you don't allow me to keep the recipients when it's a template, so whenever we use the template now we get this ridiculous notification that there aren't any recipients. Of course there aren't any recipients, you…
-
Workflow not working
Hi all, We've put a workflow together (see picture attached). The plan is as follows: a volunteer fills out online form (see attached) and selects a community group (A, B or C) to support with current flooding issues.
-
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…
-
Is it possible to copy an automation workflow from one sheet to another sheet?
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need to manually set up the workflow on my new sheet. Thanks!
-
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.
