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
Help with Sites and Sheets
I'm struggling to create two things in my Smartsheet. I'd like to have a countdown in the completation date from "today" until our project's expected final day. And capturing the %done of the project in smartsheet, maybe I'm doing something wrong but the =AVG() is not working for me. I'd like the program health to indicate…
Text/Number column is editing my number
I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?
Are Attachments Protected or Secure?
I apologize if this has been asked before but I could not find the answer. My organization is looking to see if attachments are considered protected and secure? For example, if we have something that contains Personal Information for an employee (not HIPAA), would this information stay confidential? Does Smartsheet provide…
Error message on deleting attachments
I was going to delete attachments from the Workspace Attachment Summary window. I had attached a HowTo document to a Master sheet -- and each time a new sheet was created, the attachment came with it. So, time for cleanup and a change to my process. I selected the 6 attachments and selected "Delete All" as some had…
Importing Excel sheet clarifications
I've been importing an Excel sheet for a while now. Formerly, I didn't care about the Primary column because I was just using the sheet as temporary means to get the data to the final sheet - where column types is more important. The first column contains a series of 1's and 0's. In the final sheet, that is a check-box…
Date conversion
I feel like I'm off my game today. I hope I'm wrong here but this is what I have. Sheet 1 has a Date column For other design issues, that date is linked to a Text/Number formula on Sheet 2. In sheet 2, I want to take the date and compare it to a real date in the sheet. Addiing =[Text Column]23 to a date field results in a…
Multiple answers
Is there a way to give a user the option to select more then one answer. Drop downs only allow for one option.
Template for a Business Startup?
Hi Smartsheet Community, I'm loving this program, and have created a mockup sheet for task that need to be acomplished for a new business startup. Using the trial version now and will signup as soon as we get our final go ahead from legal. So my question is if anyone knows of a template that exsist for new business…
How to count number of flags in column?
What formula would I use to count the number of flags that are up in a column?
How can I make an automatic subheader under the parent header?
Hello all, Everytime I want to make a new row I have to copy and paste the subheaders and then indent it to make the new row a parent row. How do I have the subheaders automatically come up without me having to copy and paste the subheaders and then indent it? Is there a logical function I can use? -Vivian