Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
sharing a smartsheet
How can people I am sharing a smartsheet with print out all the detail in a pdf not just the gaant chart?
Form Submission
When submitting a form, I want a copy of the form automatically sent to a certain email address. I would also like the manager completing the form to put in their email if they would like to be cc'd. I know I can send the row once it reaches the sheet, but is it possible to always have an email address cc'd on the form…
Summarize Columns in a REPORT, not a Worksheet
I've looked far and wide, and haven't found a way to summarize column data in a Report. My team uses a single "Status Tracking" Smartsheet, which has a large number of columns. For some of the columns in that worksheet, I have created Summary Rows with Count or Average Formulas, so I can determine the number of records for…
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
Feature Request - Open Sheet Notice
It would be great to have a feature when someone first opens a sheet that it pops up telling them important information. Such as "Do not use this sheet, it is for records only"
Create Multiple sheets from template
Hi, I am new user and was wondering if anyone can help. I have created a template which has questions users have to answer. I need to send this out to 100s of users and will need to do this annually. Is there a way to use the template to create multiple sheets which can be assigned to multiple users. I need each person to…
'Enter' submits Smartsheet form
Hi all, Is there a way to change the settings for a form so hitting 'Enter' doesn't automatically submit the form? I have respondents who are inadvertently submitting a partial survey. Thanks in advance, Renae
Having problems with sums
Hello. I am trying to add some totals in a column. It's a pretty simple thing that I do in Excel all the time. I am just clicking on a few cells in a column to be part of a total. However, after a do about 3-4 cells, it stops working and the cell with the total says #UNEXPECTED OPERATOR. Any idea what I'm doing wrong?…
Is it possible to conditionally format a row based on the status of it's dependencies?
Hi, I'd like to colour a row, or perhaps set a column based on the status of that rows dependencies. Does anyone know if this is possible? Thanks in advance, Tom
% fields not displaying correctly
Why do my % fields sometime automaticly round up (4.6% displays as 5%) and sometimes they display correctly (4.6% as 4.6%). When I average those fields out it is wrong when i have the fields as %. Here is what I enter into the fields with the % turned off Mar 30 Apr 3 April 6 Monthly Average 0.048 0.040 .050 .046 Here is…
