-
Copying a row without sub-rows
I'm trying to easily capture completed project data by copying a single row's data to another sheet so I can run reports off that new sheet's data. HOWEVER, the automation to copy rows copies all the indented rows with it... I'd like to just copy the data from the single row. Is that possible? Does somebody have a…
-
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}…