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 2016 Posts
Archives for December 2016
Discussion List
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
Roadmap Missing
The Product Roadmap seems to be missing. Is it being redesigned, or has it been removed permanently? We would often make suggestions to specific features listed in the roadmap, and I think having certain user input into pre-release features is a better way than releasing it all at once on the public. As I recall, a lot of…
Changing actual start date - Predecessors delete
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start date of a line item then it deletes the predecessors. I know that to avoid that from happening - You must either change the…
If/Then Statement
What would be the best forumla to have one cell change status based on multiple other cells? For example, I have a sheet with four columns. I need a formula that won't change Fake Company 1 " Contract Closed to "yes" until all Lower Tier Vendor's associated with Fake Company1 have "yes" under Contract Closed.
Possible to close Comments window using a keyboard shortcut?
Does anyone know it the Comments window can be closed using a keyboard shortcut or are we required to click on the 'X' icon in the top-right corner?
Capturing Email Responses
I would love and really need to capability to for Smartsheet to capture responses to emails in the comments. Example if a user sends a document for comments through SmartSheet email as users reply back I would want to see those replies in the comments. Rather than having to log into smart sheet leave a comment and then…
Power Bi dashboards?
Hi Community i'd be interested to know how useful members are finding the Smartsheet linkage with Power BI to create some excellent Graphical dashbards possibly as a supplement to the more Numerical View achieved in Sights? Could any of you describe your Use case? Could you describe how easy or Difficult it was to set up?…
format row with color on date
i have two columns, one is today date collumn and other is review date coloum , if my review date was 20-12-2016 and it today date is 21-12-2016, and it expired i want full row colour changed format and receive reminder setup. thanks you
Change the size of Harvey Balls
Hi SS Users! Just wondering if there is a way to increase the size of my harvey balls? I have a sheet being pulled into a report, and then being displayed into a Sight. The harvey ball appears on the Sight, but looks ridiculous becuase it is soooo small. Is there a way to increase its size? Ive tried to change it in both…
How do I automate an import data from CSV so that I get service tickets for my team based on priorit
Hi All: I would like integration of our Helpdesk system with a Smartsheet file (i.e. Team Task List by Priority template). The Helpdesk system is our database of service tickets that my team will need to work on and resolve. Having the capabilities of Smartsheet such as team sharing, update requests, and card view would…
