-
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?
-
How can I notify staff when an assignment in a contact column changes?
I have a sheet set up with a contact column so I can assign staff to a request. This assignment is automatically triggered based on request type. When the staff are assigned to the new row, I set up an automation to notify them via email of the request. This is working well. However, sometimes the assignment is changed…
-
Is there a way to 'automate' the filling of a DATE column via a formula?
Hi Community, My scenario: I am using a MIN/COLLECT formula to pull the earliest date from a list after a set criterion is met. I now want to have the same field 'lock-in' the date when another criterion is met, column x = "Scheduled". I am unsure if this is possible without creating a circular dependency. I did think to…
-
Can I automate emailing attachments?
I have an approval automation set up but it does not send the actual attachments when "alerting someone." Is it possible to create an automation that emails the files that have been added to rows? If not, has anyone found a workaround? I've seen others post the same problem, but I haven't found a solution yet. Thanks!
-
How to use Smartsheet's legacy resource management function to highlight conflicts and auto change
Hello, apologies in advance if this appears to be a rather basic enquiry, however, I'm not familiar with Smartsheet's legacy resource mangagement tool. I've had an enquiry from a colleague who has a Gantt chart sheet showing his team's tasks (as below). He's wanting the sheet to be able to add holidays for people and for…