-
Email Notification : Removing the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Show all the recipients on an email alert
It would be great if possible to show on the c/c part of an email all the recipients copied on alerts. I have many users requesting to have such functionality in Smartsheet alerts.
-
Dashboard Charts - Secondary Axis, additional data points, target line
Hello - It would be nice if we could add a secondary axis to charts to show additional data points in one chart. Attached is an example of this ability in excel.
-
Approval Request Automation: Need User to Fill Out Fields
Hello, I'm trying to create an Approval Request automation, but I need the following actions: When approved: for user to type out their name When declined: for used to type out a reason I'm able to select the columns I want the information to be populated in on the automation, but it shows an error message. Is there no way…
-
Form Security Permission Setting
Our company has found that form submissions are not as secure as we need them to be. Anyone with the form link can submit an item that posts to the source sheet regardless of security permissions. In essence, with the link, Customer X can post an item to Customer Y's sheet. Please consider adding another level of form…
-
Same Formula (=WEEKNUMBER(Date@row)) Different Result
Hello, Smartsheet Gurus! I am stumped. I am using the same =WEEKNUMBER(Date@row) formula in two different sheets. One sheet is pulling information from the other using the project number, employee name, and week number. I could not figure out why the data is wasn't pulling over because I used the same setup over and over…
-
Help with INDEX/COLLECT with a MAX/COLLECT
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would like to use the row with the MAX Fully Executed Date. Below is the formula I am using: =INDEX(COLLECT({IA Assigned}, {RTO…
-
Is there a way to break out found Rows from a LInked Sheet into sequential rows in a new sheet?
Hi folks. Let's say I have a sheet with the following data: Then I make a second sheet that links to the first, looking for matches of both the Name and Date. What I want, in this second sheet, is to eventually show that on 12/25, Matt is Eating a Sandwich (first row of new sheet) and Using the Toilet (second row of new…
-
Question about what Data Shuttle Run Options
Hello, I am not sure i understand what the scheduler means in the data shuttle I have set up. Does the below mean that my scheduler will run every hour from 5 am to 8 pm each day? I need it to update often but not sure if this will do it or not. Thank you to those that are smarter than me :-)
-
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…