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. Archived 2017 Posts
Archives for May 2017
Discussion List
Problems with Data Erasing or Disconnecting in Smartsheet
Is anyone else experiencing problems with content and data such as formulas suddenly disappearing and you find yourself adding the formulas back to your designated fields even though your saved after all of your changes and everything is working fine? This is the second time I have noticed this has happened. Which is…
Order of columns to select when sending email
When I want to email someone, I don't want all the columns sent in the email. I click on the edit columns to select what I want to send. Many times it's just one or two columns that I want to send. However, it is very difficult sometimes because we have a sheet that contains many columns. The order of the columns seems…
Performance issues with LOOKUP() formula
Hi, I have a Smartsheet with around 3600 rows and ~20 columns. After introducing a simple LOOKUP() into one column of these 3600 entries, the Smartsheet page has become dead slow. Browser is giving error "An application is slowing down ...". Tried opening this sheet in both Firefox and Chrome browsers but same result.…
"Gantt Chart" and "Sort by Date" do not work as expected
I am trying to create a consolidated sheet for past projects. I have inserted each project's Start-date and End-date as links from other cells. However the gantt chart is not correct, please see the first attached screen; i.e. missing project A and project E. Also if I try to sort by start date, the sorting result is…
Adding a Hyperlink to a Web Form
Hi All I'm wondering if there is a way to insert a hyperlink as a default value either into a column or a web form so the user than click the link but doesn't have to create the link in every row populated by the web form. I see a hyperlink can be added directly to a sheet, but my users aren't happy with that. They're…
Filtering for a Particular Value When Multiple Exist
I am using a text type column to populate multiple values that I would like to be able to filter on. However, the values have letters and/or numbers that because of schema show up in the Filter output that are not desired. MS Project uses commas (and some other values that you define) as separators. Does Smartsheet use…
Summarizing a Customer Satisfaction Survey that is ongoing with monthly reports
I have created a Customer Satisfaction Survey with 12 questions that use a 5 point Likert scale. (Strongly Agree / Agree / Neutral / Disagree / Strongly Disagree). I have tested the web page and it all populates the SmartSheet fine. Additionally, the first 5 questions are about the sales person, the second 5 are about the…
Sights - How to
Hi! I am learning how to use Sights and experimenting on how I need to organize my data in the right way to make Sights work. What tutorial/webinar/video have you found MOST useful in getting started? I'm hoping to find a link that has the best tips and tricks. Thank you all!
Change drip down selection for entire coumn
I have added a column to my sheet that is a drop down list column. I would now like to automatically have these selected as, "Not Started". Is there a way to do this other than going down and automatically updating each cell?
Printing Conditional Formatting formulas
I have about 30 columns in my smartsheet tab that are populated via a webform. Is there a way to print the conditional formulas for the columns in one document so to audit the formulas for accuracy?