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
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
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…
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
Offline Usage
I see back in 2015 there were some posts about not being able to use SmartSheet office Is this still the case? and in so, does anyone have any tricks or ideas to get around this Many Thanks in advance
Cells are not aligned in the same row.
Hi, For some reason, there seems to be a misalignment between the first two cells in any row with the corresponding rest of the row. As if there is a split between them. The split grows as I scroll down. A very strange thing. The screenshot below shows the issue. I have selected multiple distinct horizontal rows. This is…
Couldnt Find my Question Raised yesterday
Hello, I started a discussion yesterday but not sure where to find it now. I would like to see if anyone has posted answers to my question asked yesterday. Please Advice. Many Thanks Senthil
Count if date is last 7, 30, X days
I have a sheet that lists feature requests. The system automatically generates a date when the request was submitted. I have summary columns up top of how many features were requested Q1-Q4 but I would like to add in counts for the past 7 days and 30 days. I would like a formula so the counts automatically update without…
How to adjust the column width in email notifications
I have a sheet that sends out regular email notifications. There are about 40 columns in the sheet. What I am finding is that the columns are only a few characters wide in my email notification. Is there a setting I can adjust to increase the width of columns in my notification emails, or at least expand some of the key…
Expanding and Collapsing Hierarchy/Outline levels
Very much would like to have the ability to expand the hierarchy to a particluar level such as 1,2,3 ... ALL. For my applicaiton Level 1 is PROGRAM, Level 2 is PROJECT, Level 3 is milestone, etc. I need to see the entire sheet open to a particular level. Looking for something that exists in Excel as well as all "outline…
Google Calendar Sync
Hi, I have successfully exported a calendar to Google, however, it is not syncing properly with updates made in Smartsheet - and has an automatic disclaimer posted within the Google calendar Settings that reads: "NOTE: Smartsheet sync is disabled for this Google Calendar." How can I remedy this? Thanks for your help