-
Dynamic Alert Email Automation
Is it possible to create a dynamic email alert automation that is driven by a Dropdown List column type such that the email content changes based on the row's cell selection from the drop down list? e.g. if Project milestone changes to Kick-off, the email alert is X and if the milestone status is Needs Assessment, the…
-
New Taskbar Color for New Project
Hello All, I recently having been building up smartsheet for our agency and I had a questions about the taskbar colors. Right now I have a template that will be used for all new projects. The taskbar defaults to the light blue color. When coworkers use this template, I'd like the default color to be randomized so all…
-
Form not auto-populating worksheet
Hi When someone has submitted a form, they've received the confirmation that it has been submitted but it is not showing on the worksheet, so the follow-up workflows have therefore not been triggered. Could this just be delayed in reaching the worksheet, or is there an error I need to find either in the form or the…
-
When will Smartsheet be back with full functionality?
Hi! We have serious issues with Smartsheet. I can't add new rows with forms, automation / workflows doesn't work, notifications are not sent. For us it a total chaos as every job goes through smartsheet and now more than 20 people can't work. Please help. Thank you, Norbert
-
Add an attachment to email
Hi all, is there any way to attached file that generate via automation in the email alert? i mean to attach the file and not a link to file @Andrée Starå could you assist?
-
Mandatory fields for updates
I would like to know if in an automation workflow is it possible to make it mandatory to modify or change a column data or field in the request before making it complete. I have set a Field of the status of Our customers, and in a certain moments I need our sales team to update some columns,... I did a workflow to send…
-
IF(OR(Find Statement
I am trying to build a formula that searches in a column for a certain word using FIND( and I would like to add OR to that. I am using this formula and it is working fine: =LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) I would like to add FIND("GZ" so that it returns either after finding "TZ" or "GZ" Thank you!
-
Automatically update Sub-Tasks when parent is changed
I am looking for a way to automatically update the completion status of sub tasks if the parent task is updated to completed. I have a project plan that varies based on how complicated the client is. If the client is large and complicated each task needs to be signed off individually, but if it is a small client, entire…
-
Is it possible to get copies of emails sent out via automation (to a contact in a cell)?
I have an automation that sends out "Congratulations, you passed!" emails based on form submission/sheet data. Is it possible to retrieve copies of these emails that were sent in the past? In case the info is needed, my settings are "unrestricted," and email addresses are from contacts outside of my organization. Thank you!
-
Possible for change cell value automation to append text to itself?
Confirm please if this is possible or as I suspect, not. Would it be possible in automation to change the content of a text cell from say: Some Name to Some Name - Cancelled The challenge is that I need the old value to be referenced during the update. Any potential hacks around this?