-
Change cell value automation not triggering automoatically
I am trying to change copy a cell value when another condition is met. The workflow I have setup works if I run the workflow manually but it doesn't trigger automatically. I am clicking save and refreshing etc. The only way it works is to do it manually. This isn't an option as I will probably have 50 of the same…
-
Is there a way to auto-generate an MOM (Minutes Of The Meeting) type of sheet/report from your WBS?
I'd like to know if there's anyone here who has tried generating an MOM (minutes of the meeting) directly pulled from your WBS? The intention is for PMs to prevent doing duplicate work, one is updating their WBS, then another sheet or document type for their MOM. Appreciate anyone who can share their experience and best…
-
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…