-
User-submitted forms: Is there a way to have email address and name be automatically added to my Con
I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts. How can I set my form…
-
Feature Request - Edit Scheduled Report Send Email
Under Report > Send as an Attachment it is possible to schedule a recurring email. It is also possible to edit the recurrence deliver options but not to edit the email itself. You have to delete the recurring email and start over. Could we please have the ability to edit that email message? Thanks, Nick
-
Adding to dropdown list
I have a dropdown list created, and I have it set to not restrict to the dropdown list only. I would like to know how to easily add values to the dropdown list without having to go into the column properties. Logically I would think if I type in a value in the cell it will add to the dropdown list, but it doesn't work that…
-
Creating Sub-Auto Numbers
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Remove Cell Linkage
I had previously created a sheet that inputted data via cell linking. However, the use of that sheet is no longer needed so I deleted it. The problem is that the sheet that was 'pushing' the data still shows the outgoing cell link. How can I remove the cell linking?
-
Defining a range using a variable as the row #
Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "15", something like =SUM([Column1]Row:[Column4]Row) where "Row" could be sourced from the…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Calendar View - Printing
When printing in Calendar view, the names of Months and the Days are very faint, almost unreadable. I can change colour of cells but can't seem to change the names of months and the days to bold or some darker colour. I'm a new Smartsheet user so won't be embarassed if you let me know it is something very simple.
-
Traffic lights count by colour if children
Hi there, I'm trying to count the number of projects according to their traffic light status across about 7 sheets. Given I want to display this in Sights as a Metric, I can't use a report so I have a sheet linking to the summary information from each sheet. When I use the Countif formula to count those that are "Red" it…