-
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…
-
Clear check-box, without clearing associated Due Date columns
Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column. Is…
-
How can I create an automation so the person filling out the form receives an automated email?
Hello! I have an automation already set up so that I will get an email when someone fills out my form. However I would like whoever completes the form to get an automated email saying "Thank you for your submission. We will respond within 3 business days." Is this possible? Thank you!
-
Update TODAY() function automatically improvements
Hello SS Community, I have been using the required automation to update my sheets automatically since I am using the TODAY() function on my rows. The current setup I have is to check an unchecked box and vice versa. Other solutions found here:…
