-
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…
-
Add business days to automation
I have rules that remind a number of people of an upcoming end date. I want to do it two WEEKDAYS/BUSINESS DAYS in advance of the due date. The best work around I've found, is adding a "day of the week" formula field, and then making separate rules for end dates that fall on a Monday or Tuesday. Since the trigger cant be…
-
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…
-
attached file to mail
its would be excellent if when i generate file with automation, its will be sent via email and attached to mail conversation' not link .
-
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!