-
Automated interactive Subject line and email / Update request
I love the the automated update/approval emails feature and i wonder if its possible the subject line can add more information with a code trigger from one of cells and not to have the exact same subject all time Also the sent to email to be triggered from contact email and not same email setup Thank you
-
Conditional formatting in alerts
How can I get conditional formatting to display consistently in messages sent through alerts? I have one sheet where this works well, and colour-coded rows appear as just as they do in the sheet itself. However, I have another sheet where only some of the formatting is shown, and none of the colour coding (which is based…
-
(G)Mail as input for a new task in a smartsheet table
Hi all, how can I create a new task in a smartsheet table by receiving an email via gmail? And sending back the (ticket) number to the sender? Thanks, Joachim
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
Validate an email address in a contact list
Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: test.user@smartsheet.com test.user2@smartsheet.com (Please notice the "2" in this email.) We use a form to populate our sheet and the form user is required to type(paste) the email address…
-
Accessing a Group Created by a Colleague
My colleague created a large group of contacts in our organization with the intention of using this group for email permissions in Dynamic Views. We are both Group and System administrators on our business account, and I am able to access and edit the group in Group Management, but the issue is that I am not able to access…
-
Email provider, not compatible
We use Microsoft Outlook 2016 desktop version and do not have 365. We also use Ionos webmail. Any suggestions on attaching emails without 1) saving the email as a PDF and adding an attachment or 2) copying and pasting the email contents into the comments?
-
Smartsheet Alerts - "Message Only" option duplicates the message body
Hi, Can someone explain to me how to get the "Message Only" alerts to only display the supplied message once? I set up an alert on a sheet that triggers on a date value. The intent of this alert is to act as a reminder, and send a link to a Smartsheet form to a user on a sheet who submitted data in the past X days. So I…
-
Notification with assignment
I have a sheet set up to notify the person in an assigned column when that row changes. My intention is that if I make a change and assign it to my staff person, they get notified. However, if I make the change on a row that is assigned to me, I still get notified myself. How do I make a condition so that it checks for the…
-
How do I change the sender name
I built a sheet for a team member who owns a process. As the sheet owner, my name appears as the sender for updates and alerts. Recipients may not open the email because they do not associate me with the process, meanwhile they think the process has not started because they are looking for an email from my team member. The…
