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
Sending out sheets automatically
Let's say I want to send out my schedule every Friday to a few specified emails. Can I set it up to do this automatically?
Completed date stamp formula runs when sheet is saved every time
Hi Smartsheet community, I currently have a formula the runs when a column drop down is selected to "Completed" =IF(Status4 = "Completed", TODAY()) However, every time someone else saves the sheet, the formula runs again and overwrites the old stamped date. This never happened before and I would like to know if there are…
Add Trend Lines/Line Graphs to SIGHTS
Looking for a way to visualize my data in an easier way. Love how I can create trend lines for others to look at in Excel. Would love to have this feature in Smartsheet.
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
Help: Change GANTT to Year/Month in Widget
I can change my GANTT chart in the project sheet to Year/Month display. But when I create a report and display the GANTT in a widget in the Sight it will only show the GANTT by Week/Day. I need it to show by Year/Month. Can this be done with the report widget? or is there another way to show the GANTT in the Sight for the…
Free Collaborators vs Non Licensed Users
Can someone explain the difference between a non licensed user and a free collaborator? e.g. * Do they need a smartsheet account? * What can and can't they do?
User email transfer
Hello, Our company just changed name, and hence email addresses have changed (from name@oldcompany.com to name@newcompany.com) I'm the admin, and trying to get the users switched to their new email address. When a user tries to switch their email via their personal settings, it's not possible - perhaps because I had…
Search/Filter
Hello I am new to this and am on my trial and am wanting to use this to build a search/filter for lots of different office furniture categories and then specific options within each category at lots of diff price points. I'm having a hard time figuring out how to create something similar to this. Does anyone know if there…
Managing Active Documents in Smartsheet
When it comes to editing a document that is stored in Smartsheet, I'm looking for the best way to manage active documents (e.g. word template that needs to be edited on a continual basis). It is a huge pain to have to save it somewhere else, edit it, then delete the old doc in Smartsheet and upload the edited one. Please…
How to show a percentage in a cell with text mixed with formula
Hi, I have a percentage complete cell which is working correctly when the following formula is used and the cell is set to show as a percentage: Formula: =SUM([Column5]24, [Column5]29, [Column5]33) / 3 Result: 25% However if I add text to the front of the formula, the result changes back to an integer: Formula: ="Progress…