-
Removing row data from update request email
For security concerns, we would like not to have the row data emailed in an Update Request. I will interpolate the context of the row in the email myself so would only need the subject and body of the email sent, along with the link to the update form. Any help is appreciated. Thank you.
-
Grid with hyperlink
Hi have a smartsheet grid that lists a series of reports. One of the columns is a hyperlink to a sample of the actual report. The hyperlink shows up if I open the grid. But when I report on the grid and include the report in a dashboard, the link is not active. How can I display this list of reports from the grid so the…
-
Sum of Child Rows - Linked Text
Hi all! Hoping the community can help me w/this one. I have a database in which various quantities of part numbers are listed based on what model the system is, etc. Each of the quantities is display text (a number, i.e. "6") w/a hyperlink to the listing of the part itself in a different sheet. I'm trying to sum up each…
-
Setting up metrics
Good afternoon, New to smartsheet, When I set up my sheets shoudl I be setting up the "metrics" that I want to capture on the top of the sheet to easily transfer to a dashboard/widget?
-
Date Submission in Form
Hello! We have a form that is collecting a Date Submitted. For the date drop-down in the form, is there a way to disable dates that are before today's date? We don't want the user to be able to select a day that pre-dates today's date.
-
URL method to send information directly into a Smartsheet?
(Total noob with SmartSheets) I’m using Smartsheet URLs in an LMS training course at the end for feedback and suggestions. Currently we construct the link inside the course and it opens a web form when clicked with some of the fields pre-filled in based on user info from our LMS. It’s good to insure they don't have to type…
-
Include a subset of a grid in gantt view
Hi! I have a grid that is a project plan with start and end dates. I want to display a section of it in gantt view on a dashboard. I accomplished this by creating a report first. Is there a way to do it directly from the original grid - to somehow say "include all lines that start with the letters PHX" or something like…
-
Reports completely changed...?
Overnight, it appears that Reports have changed. My team can no longer edit previously created reports, even with Admin access! In addition, when creating a new report, I now have to choose between "row report" and "sheet summary report". Neither of them work correctly; none of the columns from the source sheet are pulling…
-
Not Counting Blank cells in Checkbox formula
Hi All, desperately need your help on this one. I've been searching the forums and tried this formula so many different ways and cannot get it to work. :( I have checkbox formula that is simple enough, I want it to check the box if we met the delivery date that was planned. So I'm comparing delivery date planned vs.…
-
Enable Confirmation Email: Add Asterisk
In order to continue the good work you've done on Forms UX, I suggest that when a user checks "Send me a copy of my responses," the form's subsequent "Email address" field label could be followed by a red asterisk, similar to all other required fields on the form. The client-side error-checking is nice with its red border…
