-
Request to Update: Is there a way to make some fields required
I have a form where the user is presented a form with some of the fields from the table. Once the approval routing is complete, the user is prompted to fill the remaining fields. Is there a way to make some of these fields mandatory? Currently, all of the asterisks go away.
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
-
Is there a way to see all recipients of an alert within the automated alert email?
I have created a Smartsheet which will sent automated alerts to multiple people. Everyone getting an alert is just seeing his/her name in 'to' but not the other names. So the person does not know who is informed as well. Is there a way to change it so that every recipient sees to whom the alert has been sent?
-
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…
