-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
-
How can I summarize 26 sheets and then generate a document
This is a complex one that has been rattling around my brain for a while now. We have 26 sheets, each has a form tied to it that allows folks to enter information based on review/compliance questions. Example: AB 1.1.1 Did you observe them following rules? - If yes they receive a % score if No they receive a 0 and in the…
-
Customizing Display Fields for Slack Notifications
My team would like to see a future capability of being able to change which fields are displayed for Smartsheet automated notifications on Slack, similar to those in email. At time of publishing, only the first four columns that are filled out are shown. We've identified a workaround by moving the column we'd like…
-
Sheet not coming up for workflow
I am trying to create an automation event that copies a row from my Order Tracker to my Shipping Tracker but none of my sheets are coming up for me to select where to copy to. At first I thought that it was because my Logistics Manager created the Shipping Tracker but I have edit permissions for that and also, none of my…
-
Add Links to WorkApps in Automation Messages
Currently when creating an alert automation you have the option to include Message Only, Link to Sheet and All Fields, or Link to Sheet and Specific Fields. We are trying to promote WorkApps instead of users accessing the source sheet, so it would be better if we had two additional options: Specific Fields with no Link…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Merged: The ability to send notifications to groups rather than individuals
This discussion has been merged.
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
Locking certain columns for parent row only
Hi, Is there a way we can lock certain rows of the parent row column so that no one can edit it? However, the child rows would not be affected by it. Thank you for your help!
-
Automated reports with attachments included
I have a few automated reports that go out every Monday. Is there a way to have this report (PDF or Excel) include the documents that are attached?
