I'm working to set up a ticketing system and I want to have two automated emails. The first is to acknowledge the request, which is set to trigger when the support person changes the status to "not started" or "in progress". This automation works perfectly (1st set of screen shots). The second automation should trigger…
We changed our sheet permission to be unrestricted and updated our notifications to be sent to anyone. We did two tests, one to my personal email (included in our domain) and one to my assistant's personal email (not included in our domain). I was able to receive the email however my assistant did not. Is there a way for…
Hi folks, I've been Googling around to try and find some information regarding my challenge. Basically I need to set up this formula to assign a Projected Due date based firstly on the Date of Submission (Date Column) +5 days for a small project or +10 days for a Large project. I have columns filled through for entry for…
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
Hi All Is it possible to change the linked sheet in the email that is received through the automation workflow? Here is my challenge // Automation - IF Status Change from GREEN to RED THEN notify individual and COPY ROW(s) to task sheet Notification Email - Hi [Name] the following items have changed status, please review…
Hello again Like a typical N00B I'm having wonderful ideas with almost no knowledge of the product (go easy, I'm just rolling into my 5th hour in 2 days of using it) I wanted to know if anyone has any experience or thoughts on how best to approach this scenario as I've found some challenges with my current workflow…
I am configuring an approval workflow where the approval request is being sent to a client contact. As part of the approval process I would like to give the client the ability to upload attachments and add a comment if desired. Since there could be existing attachments/comments that I would not want the client to see I do…
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
Hello, I have a number of automated workflows setup using Dynamic Cell Data in the subject lines and message bodies. This morning I was informed that some received message with blanks were the Dynamic Cell Data should have been. Has anyone experienced this issue before? No columns had been adjusted prior to cell changes.…
