-
Merged: Attachment & comment Inclusions on email alerts even when added days before the trigger…
This discussion has been merged.
-
Automation to send Alert "Hourly" results in error
I have asked for an Alert to be sent Hourly each time a new row is added to my sheet: but when I hit Save I get the following error: I did click on Learn more which tells me: "There are some tasks you can’t do with hourly, daily, or weekly workflows If your workflow is set to Hourly, Daily, or Weekly, you can’t use any of…
-
No Sheet Title in Workflow Messages/Update Requests
I noticed that when I create a status update workflow with a custom message, the message comes through without any reference to the sheet. This means the recipient won't know which project they're providing a task update for. Is there an automated way to include the sheet title in the custom message?
-
Pie Chart Linking to Multiple Links?
Hello, I am working on a Dashboard and have created a widget with a pie chart. I have been asked to link four separate links to each of the four categories within a pie chart (attached below). I see via "Widget Behavior" I can click out to one sheet/link. Is this even possible to do? I have an idea for creating four…
-
Index Collect Permissions
Hi all, I have a Smartsheet which looks up values from another sheet using Index Collect, which is working well. However other users with Smartsheet license and with a free license will be loading the sheet who don't have access to the source data sheet. I don't plan in opening the this (the destination sheet) hoping that…
-
Automation Email Sends multiple rows and I only want 1 at a time.
I have an automation that says "if X happens send me an email" Does anyone know what the timing trigger is that determines if 2 rows are updated then it sends you both rows in 1 email? We want to use this email to alert a team to do something and it looks GREAT when you get 1 row after the update. However it looks like…
-
Numerical "Priority" Method
Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to…
-
Automation not working consistently
Hello everyone, I am getting inconsistent results with the following automation on some of my sheets. Some of these are working fine but here is an example of one that is not: The workflow itself is fine because I can manually run it and alerts will be sent. So my problem is really only that the Assignees above will not…
-
Duplicate Notifications and to Everyone in the Workflow
Issue: The notifications for the CD level and RVP level are duplicating and sending to everyone in the workflow. 😬 Something is wrong with the workflows I created. Sheet Design Each row has someone assigned {Response Assigned to} to add the response to the {Center Responses} column. The person in the {Response Approved By}…
-
How to make Networkdays formula display less than 0 values
Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…