-
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…
